COUNTIF With multiple criteria

[Ellie_86]

I am trying to find the number of claims within a worksheet that meet three critera's.


I have tried to use

=COUNT(IF('RTW Same Employer'!M6:M64,"<=24",IF('RTW Same Employer'!I6:I64,("<=31/03/2011"),IF('RTW Same Employer'!J36:J64,"5"))))


=SUMPRODUCT(--('RTW Same Employer'!M6:M64<="24")--('RTW Same Employer'!I6:I64<="31/03/2011")--('RTW Same Employer'!J36:J64,"5"))))


Any suggestions, corrections or solutions welcome!


Thank you


Ellie

 

[Hui]

Ellie


Firstly, Welcome to the Chandoo.org Forums


Have a look at:

=SUMPRODUCT(('RTW Same Employer'!M6:M64<=24)*('RTW Same Employer'!I6:I64<="31/03/2011")*('RTW Same Employer'!J36:J64=5))

 

[Ellie_86]

Hui, i may possibly be your new biggest fan.


Thank you!!!!!!!