I need a formula or a macro which will count using two conditions a
range of cells. The problem i have one of the conditions is a "less
than or equal to" a time.
the formula below i have used but it gives a false count, either 0 or
counts only one of the conditions
=SUMPRODUCT((A1:A25="<=00:03")*(B1:B25="AM"))
i have also used the 'Ctrl-shift-enter' aswel.
any ideas??
--
SamGB
------------------------------------------------------------------------
SamGB's Profile:
http://www.excelforum.com/member.php...o&userid=31263
View this thread:
http://www.excelforum.com/showthread...hreadid=512601