Sumproduct with date range
what is the product name and what value are you testing for (My formula was
just an example).
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"ermeko" wrote in message
...
Thanks,
=SUMPRODUCT(--(ISNUMBER(FIND("product",A2:A200))),--(b2:B200=--"2006-08-01"
),--(B2:B200<=--"2006-08-01")) gives zero but there are dates like
2006-08-01 23:02:00, 2006-08-01 22:00:00 in B column.
When the begining and ending date is the same it does nor sum the
quantity.
"Bob Phillips" wrote:
=SUMPRODUCT(--(ISNUMBER(FIND("product",A2:A200))),--(b2:B200=--"2006-08-01"
),--(B2:B200<=--"2006-08-31"))
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"ermeko" wrote in message
...
Hi,
I want to count an "A" column where the column "B" is between a given
date.
The date in column B has a date and a time("dd-mm-yyyy hh:mm:ss").
The
date
arguments in the sumproduct are in the "dd-mm-yyyy" form. The formula
should
find "like products", not the exact match.
Thank you,
ermeko
|