View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SamGB
 
Posts: n/a
Default Count using 2 conditions, one of which being a "less than or equal to" - URGENT


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