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

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

2. Re: Count number of event types occuring by month (SUMPRODUCT?)

Assuming C3:C200 are real dates.

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

3. Re: Count number of event types occuring by month (SUMPRODUCT?)

Formula:
`Please Login or Register  to view this content.`

1,2....-month number.

4. Re: Count number of event types occuring by month (SUMPRODUCT?)

Hi John, I have not seen the use of --, what does this mean? Thanks!

I have mocked up a template, assuming F2 will always be the first day of the month. It counts anything bigger or equal to the first day of the month and anything small than the end of that month for the criteria in Row1.
Excel - CountIfs.xlsx

5. Re: Count number of event types occuring by month (SUMPRODUCT?)

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}

There are currently 1 users browsing this thread. (0 members and 1 guests)