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?