You can use the same principle using COUNTIF:

=COUNTIF(V45:V1014,"="&AU52) - COUNTIF(V45:v1014,""&AV52)



On Mon, 14 Nov 2005 16:37:07 -0800, "roy.okinawa"
wrote:

Ron,

This formula is adding the dates. I need just to sum/count the total of
each date contained between the "From" "To" dates.

"Ron Rosenfeld" wrote:

On Mon, 14 Nov 2005 15:07:03 -0800, "roy.okinawa"
wrote:

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:N1014))))

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

Your formula is only looking at the month. If there are multiple years, it
will detect all the data in all the January's for example.

If you want to SUM a series of entries between two dates, that are entered in
AU52 and AV52 then:

=SUMIF(V45:V1014,"="&AU52) - SUMIF(V45:v1014,""&AV52)


--ron


--ron