Have you tried

=SUMPRODUCT(--(rng=--"2005-03-01"),--(rng<=--"2005-03-31"))

which counts all items in March

--

HTH

RP
(remove nothere from the email address if mailing direct)


"jimkozak" wrote in message
...
More information------------

If the selected cells do fall within a date range, corresponding cells,
need
to be summed. I am using this to sum items that are shipped in a given
month.

"jim kozak" wrote:

Trying to use conditional sum for a range of dates. this used to work
in
Excel 95 doesn't seem to work here.