PDA

View Full Version : Solved: Excel countif multiple criteria



WYLIE
05-10-2012, 01:05 AM
I’m having trouble doing a count of multiple conditions in different columns in excel.

The condition I am trying to count is when it meets my initials "CW" against one of the conditions "MHA SOAD" and how many times does it occur.

I have tried numerous of code using the Google search but it's still not working correctly.

i.e.
=COUNTIF(RecordedLog!C4:C57,AND(RecordedLog!C4:C57="CW",RecordedLog!F4:F71="MHA SOAD"))

Please find MHlog.zip attached

Bob Phillips
05-10-2012, 01:41 AM
This should do it

=SUMPRODUCT(--(RecordedLog!C4:C52="CW"),--(RecordedLog!F4:F52= "MHA SOAD"))

BTW, what is your avatar a picture of?

WYLIE
05-10-2012, 07:30 AM
Thanks for you help xld, I came across =SUMPRODUCT on a search and works :)

The avatar picture is of me in Tanzania on safari last year, just a little reminder of where I want to be.