=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