Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
countif question using two negative number criterias
I am trying to use the countif function to identify account aging. For
example how many fall within a range of numbers: over -90; -90 to -61; -60 to -31; -30 to -1 range. The greater than symbol and less than symbol are throwing it off. I'm not sure how to correct it. Any help would be greatly appreciated. This is how I have it set up: =COUNTIF('Janet-CURRENT MTH'!$M$6:$M$250,"=<-91") =COUNTIF('Janet-CURRENT MTH'!$M$6:$M$250,"<=-90")+COUNTIF('Janet-CURRENT MTH'!$M$6:$M$250,"<=-61") =COUNTIF('Janet-CURRENT MTH'!$M$6:$M$250,"<=-60")+COUNTIF('Janet-CURRENT MTH'!$M$6:$M$250,"<=-31") =COUNTIF('Janet-CURRENT MTH'!$M$6:$M$250,"<=-31")+COUNTIF('Janet-CURRENT MTH'!$M$6:$M$250,"<=-1") |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
is there a way to have 2 criterias for COUNTIF? | Excel Discussion (Misc queries) | |||
Countif with two criterias | Excel Discussion (Misc queries) | |||
2 criterias for countif - | Excel Worksheet Functions | |||
Countif, two criterias need help | Excel Worksheet Functions | |||
countif help for multiple criterias | Excel Worksheet Functions |