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

S

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

Bob Phillips

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to locate which cells add up less than or equal to a certainnumber (where numbers can be repeate 1
COUNT using multiple conditions 2
Total or Count based on multiple conditions 4
SUMPRODUCT Can I use less than or equal to with this function 4
Multiple conditions using greater than or less than. 1
sumproduct with more than one date 5
Look up a reference which has more than 1 exact match 1
COUNT for 2 or MORE CONDITIONS 5

Top