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" <ermeko@discussions.microsoft.com> wrote in message
news:58932585-46AE-43A1-A35D-7E42AFDD0B49@microsoft.com...
> 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
> >
> >
> >