Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SumProduct Help
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
SumProduct | Excel Discussion (Misc queries) | |||
HELP ON SUMPRODUCT() | Excel Worksheet Functions | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
Sumproduct..help please | Excel Worksheet Functions |