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
Bookmarks