Computing a date range
=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?
|