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")
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.