sumproduct to count two arguments
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.
|