Count multiple criteria

[i8u2day]

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

[grizzly6969]

Please Login or Register  to view this content.

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

[Haseeb Avarakkan]

Use with TEXT,

=SUMPRODUCT((C4:C160="R1.0A")*(TEXT(D4:D160,"mm/yyyy")="03/2011"))

Also please read the forum rules & amend thread title accordingly.. I think you can delete 'Urgent Please Help' part.