Count using 2 conditions, one of which being a "less than or equal to" - URGENT

[SamGB]

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??

 

[Bob Phillips]

=SUMPRODUCT(--(A1:A25<=--"00:03"),--(B1:B25="AM"))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[SamGB]

Excellent! works like a treat

Many Thanks
Sa