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") |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
countif question using two negative number criterias
You can always use cell references:
=COUNTIF('Janet-CURRENT MTH'!$M$6:$M$250,"=<" & A1) with -91 in cell A1. -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "JD Long" wrote: 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") |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
countif question using two negative number criterias
You can also set up a helper row to class this according to aging and then
countif by the aging class -- Tips for Excel, Word, PowerPoint and Other Applications http://www.kan.org/tips "Wigi" wrote: You can always use cell references: =COUNTIF('Janet-CURRENT MTH'!$M$6:$M$250,"=<" & A1) with -91 in cell A1. -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "JD Long" wrote: 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") |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
countif question using two negative number criterias
|
Reply |
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 |