PDA

View Full Version : Solved: countif meet two conditions



Djblois
05-21-2010, 11:57 AM
I need to make a formula that will count a row if it meets 2 criteria. I tried this but it does not work:

=Countif(B2:B500,AND(">.50","<.75"))

What do I need to do?

mbarron
05-21-2010, 04:30 PM
What version of Excel do you use. If you use 2007, take a look at the Countifs function.
Or you can use:

=SUMPRODUCT((B2:B500>0.5)*(B2:B500<0.75)*1)

Aussiebear
05-23-2010, 09:43 PM
Firstly you need Countifs not just Countif, if using 2007


=Countif(B2:B500,AND(">.50","<.75"))
What do I need to do?

Try the following
=Countifs(B2:B500,">.50",B2:B500,"<.75")