Count date field that occurs in a specific month

Question

I need to count the occurrence of a specified month in my data, I used the following formula

=SUMPRODUCT((MONTH(E$2:E$9999)=2)*(YEAR(E$2:E$9999)=2011)*1)

The formula works, but XCelsius do not recognize the SUMPRODUCT function

This is my data sample

2011/02/14  08:54:21 AM
2011/02/18  11:08:57 AM
2011/02/21  10:40:55 AM
2011/04/13  09:48:46 AM
2011/04/14  09:03:58 AM
2011/05/25  06:20:29 AM

Is there another way of counting the occurrences of a specified month

Thats interesting I used to have problems with the old builds but have never had problems with the new ones. — S.P., Mar 07 '12 at 08:45
I don't think you will be able to use the SUMPRODUCT to do this, and will need to change to SUMIF or some another syntax. It seems SUMPRODUCT is very limited in XCelsius — S.P., Mar 07 '12 at 08:49

score 1 · Accepted Answer · answered Mar 07 '12 at 09:08

1

Maybe try this:

=COUNTIF(E$2:E$9999,">=2011-02-01")-COUNTIF(E$2:E$9999,">=2011-03-01")

answered Mar 07 '12 at 09:08

lori_m

I just used CONCATENATE function to ease the process, Thank you – JPVoogt Mar 07 '12 at 09:41

1 Answers1