Solved: Excel countif multiple criteria

[WYLIE]

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]

This should do it

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

BTW, what is your avatar a picture of?

[WYLIE]

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.