Whoa! What happened there

=SUMPRODUCT(--(A1:A100=--"2008-04-15"),--(A1:A100<--"2008-05-15"),--(B1:B100="Apple"))


--
__________________________________
HTH

Bob

"Bob Phillips" wrote in message
...
=SUMPRODUCT(--(A1:A100=--"2008-04-15"),--(A1:A100<--"2008-05-15"),--(B1:B100="Apple"))--__________________________________HTHBob"Bigfoot17 "
wrote in
... And
what if you wanted those between April 15 and May 15? "Bob Phillips"
wrote:
=SUMPRODUCT(--(TEXT(A1:A100,"yyyymmm")="2008Jun"),--(B1:B100="Apple"))
-- __________________________________ HTH Bob "Opal"
wrote in message
... Hi, Im
trying to generate a count that will tell me how many of 'x' are in
column B only if column A's data are within a date range eg for themonth
of June. A B 16-Jun-08 Apple 16-Jun-08
Pear 30-May-08 Apple 18-Jun-08 Orange 16-Jun-08 Apple
12-Apr-08 Pear Thanks -- Opal