View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JD Long JD Long is offline
external usenet poster
 
Posts: 1
Default 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")