Count number of event types occuring by month (SUMPRODUCT?)

Hi all,

I'm trying to count the number of events that happens in a certain month, where my date is in put in the format mm/dd/yyyy.

For example , from C3:C200 are dates and in D3:D200 are events A, B, C, D. I want to know how many times A happens in Jan, B in Jan, A in Feb etc. etc.

I've tried using SUMPRODUCT with multiple conditions but I keep receiving error messages.

Any advice?

Assuming C3:C200 are real dates.

Try
=SUMPRODUCT(--(C3:C200>=DATE(2015,1,1)),--(C3:C200<=DATE(2015,1,31)),--(D3:D200="A"))

Formula:

Please Login or Register  to view this content.

1,2....-month number.

In the context of the sumproduct, -- is converting an array of TRUE/FALSE responses to 1/0
{True,True,False,True,False,False) becomes {1,1,0,1,0,0}