SumProduct Help
Try this instead:
SUMPRODUCT((A1:A10=--"7/18/2008")*(A1:A10<=--"7/25/2008"))
or you could try it this way:
=SUMPRODUCT((A1:A10=DATE(2008,7,18))*(A1:A10<=DAT E(2008,7,25)))
Hope this helps.
Pete
On Aug 19, 3:31*pm, JCS wrote:
Hi All,
I'm trying to find the number of dates that fall between 7/18/08 and 7/25/08
in the follwoing table. *I'm using sumproduct with very little luck. *I've
tried the following formulas:
SUMPRODUCT((A1:A10=7/18/2008)+(A1:A10=7/25/2008)) yields 10 and
SUMPRODUCT((A1:A10=7/18/2008)*(A1:A10=7/25/2008)) yields 0
What I'm looking for is 7. *Maybe I'm using the wrong formula. *Any help
would be greatly appreciated.
7/18/2008 * *
7/19/2008
7/20/2008 * *
7/26/2008 * *
7/24/2008 * *
7/27/2008 * * *
7/25/2008 * *
7/18/2008 * *
7/18/2008 * *
7/3/2008 * * *
Thanx,
John
|