RE: SumProduct Help
- From: JCS <JCS@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 19 Aug 2008 11:11:00 -0700
Peter, Mike, and David,
Many thanks for your help! Pete/David, you were right my data was causing
the problem. I re-typed the data and the formula worked perfectly. In fact
both formulas worked great. Again, thank you for your help.
John
"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
- Follow-Ups:
- Re: SumProduct Help
- From: Pete_UK
- Re: SumProduct Help
- References:
- SumProduct Help
- From: JCS
- SumProduct Help
- Prev by Date: Re: Format date and time from one contiguous field
- Next by Date: Re: Lost toolbar
- Previous by thread: Re: SumProduct Help
- Next by thread: Re: SumProduct Help
- Index(es):
Relevant Pages
|
