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
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