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")
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")