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" <ermeko@discussions.microsoft.com> wrote in message
> news:08798E05-66A6-4F50-B387-B0D4573CEF2D@microsoft.com...
> > 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
>
>
>