Thread: Count multiple criteria

Hi all,

I desperately need to solve this before work tomorrow and it's already early in the morning here!

I have two columns:

Column C - Categories (3 in total - R1.0A, R1.0B and R1.0C)
Column D - Date (format = mm/yyyy)

I need to be able to count the times a specific category occurs on a specific date.

I have tried =SUMPRODUCT((C4:C160="R1.0A")*(D4:D160="03/2011"))


However this does not work. Any suggestions?!

Thanks very much

=SUMPRODUCT(--(C2:C160="R1.0A"),--(D2:D160="03/2011"))

this will show how many times R1.0A and 03/2011 match but you may have to format column D to text