PDA

View Full Version : Solved: CountIF based on logical operators



LOSS1574
05-27-2008, 12:44 PM
How to Countif based on 2 logical comparisions < or > ?

Example: I need to count all the cells in the column M2:M30 with the value of 19-29.

Current Formula only counts any cells that are less then 10

=COUNTIF($M$2:$M$30,"<=10")

Bob Phillips
05-27-2008, 01:27 PM
=COUNTIF($M$2:$M$30,">=20")-COUNTIF($M$2:$M$30,">=30")

this counts 20-29, which you may wish to tweak.