this idea
=SUMPRODUCT(((ChecksA=EOMONTH(O6,1))*(ChecksD1)))
maybe
SUMPRODUCT((($K$3:$K$151=EOMONTH($K$3,1))*($A$3:$A $151<1)))

--
Don Guillett
SalesAid Software

wrote in message
oups.com...
I have an excel test so please bear with me that what I am asking for
may not be the best way to do this. Here is what I have been asked to
do.

I have daily dates from the beginning of this year to now and
corresponding data.

Using the sumproduct function I want to count the number of time that
the data is less than 1 and at the end of the month. Here is what I
have:

=SUMPRODUCT((--($K$3:$K$151=EOMONTH($K$3,1)))*--($A$3:$A$151<1))


I am stuck on the eomonth part..can anyone help?

Many thanks.