Probably not using absolute references, which is needed if copying down

=SUMPRODUCT(--(MONTH($V$45:$V$1014)=MONTH(AU52)),(--(MONTH($V$45:$V$1014)<=
MONTH(AV52)),--(ISNUMBER(SEARCH(AS61,$N$45:$N$1014))))

I have assumed all the rest change with the row?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"roy.okinawa" wrote in message
...
Bob,

Now that I have enter the formula throughout the spreadsheet, some are
working and some are coming back with a #VALUE!

What would cause this? There is nothing different in these cells, than
there is in the ones that are working. It is dates and text.

"Bob Phillips" wrote:


=SUMPRODUCT(--(MONTH(V45:V1014)=MONTH(AU52)),(--(MONTH(V45:V1014)<=MONTH(AV
52)),--(ISNUMBER(SEARCH(AS61,N45:N1014))))


--

HTH

RP
(remove nothere from the email address if mailing direct)


"roy.okinawa" wrote in message
...
I want to have two cells where I enter the start date and end date to
sum/count totals between that date range. I can get it to work if I
just
enter one date. See below.


=SUMPRODUCT(--(MONTH(V45:V1014)=MONTH(AU52)),--(ISNUMBER(SEARCH(AS61,N45:N10
14))))

What is the rest of the formula to compute the end date as well?