A couple of ways

=COUNTIF(X58:X73,"23")-COUNTIF(X58:X73,"=31")

=SUMPRODUCT(--(X58:X7323),--(X58:X73<31))

then adapt the rest of the conditions using the same technique


Regards,

Peo Sjoblom


"John F" wrote:

Excel 2003
Looking for a function that will handle:
Count AND a range of criterea

Something like:
=COUNTIF(X58:X73,"23 & <31")
=COUNTIF(X58:X73,"30,<58")
=COUNTIF(X58:X73,"56,<73")
(but this doesn't work)

any ideas?
Thanks
--
John F. Scholten