Menu

countif question using two negative number criterias

Search this Thread

#1

Report Post

Posted to microsoft.public.excel.misc

Lorne[_2_] Lorne[_2_] is offline

Lorne[_2_] is offline

external usenet poster

Posts: 44

Default

countif question using two negative number criterias

"JD Long" <JD wrote in message
...
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")

You need a minus sign not a plus:

In cell A1 put
=COUNTIF('Janet-CURRENT MTH'!$M$6:$M$250,"<=-91")

then in A2 put
=COUNTIF('Janet-CURRENT MTH'!$M$6:$M$250,"<=-61") - A1

then in A3 put
=COUNTIF('Janet-CURRENT MTH'!$M$6:$M$250,"<=-31") - A1 - A2

etc

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
is there a way to have 2 criterias for COUNTIF?	doyree	Excel Discussion (Misc queries)	7	February 1st 08 10:50 PM
Countif with two criterias	Ricardo	Excel Discussion (Misc queries)	6	January 8th 07 11:26 PM
2 criterias for countif -	Greg	Excel Worksheet Functions	1	June 23rd 06 07:39 PM
Countif, two criterias need help	Axel	Excel Worksheet Functions	12	April 30th 06 01:22 PM
countif help for multiple criterias	tdro	Excel Worksheet Functions	2	June 14th 05 05:06 PM

All times are GMT +1. The time now is 07:11 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement