Edward Pamias
asked on
Countif questions
I want to know If I can use COUNTIF on a range of numbers? for example I need a count for
1 and 2 together as well as the following....
3, 4 and 5
6 thru 10
and anything over 11.
Currently I can only look up 1 number in a range... this is what I got so far. =COUNTIF(N15:N31,Q15)
For Example I would like to count 3,4,5, together which = 15 (see below) 6 thru 10 = 1 since there isn't 1 or 2 that would = 0
6
5
5
5
5
4
4
4
4
4
4
4
4
4
4
3
Thanks in advance for your assistance!
1 and 2 together as well as the following....
3, 4 and 5
6 thru 10
and anything over 11.
Currently I can only look up 1 number in a range... this is what I got so far. =COUNTIF(N15:N31,Q15)
For Example I would like to count 3,4,5, together which = 15 (see below) 6 thru 10 = 1 since there isn't 1 or 2 that would = 0
6
5
5
5
5
4
4
4
4
4
4
4
4
4
4
3
Thanks in advance for your assistance!
ASKER
=COUNTIF(N15:N31,1)+COUNTI FS(N15:N31 ,2) <----this one works
The others did not work. Possible typos?
The others did not work. Possible typos?
I assume you're using excel 2003 or earlier? Then use these formulas instead
=COUNTIF(N15:N31,">=3")-CO UNTIFS(N15 :N31,">5")
=COUNTIF(N15:N31,">=6")-CO UNTIFS(N15 :N31,">10" )
Thomas
=COUNTIF(N15:N31,">=3")-CO
=COUNTIF(N15:N31,">=6")-CO
Thomas
ASKER
No sorry, I am using excel 2010.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you!
Glad to help. Thanks for your patience.
Thomas
Thomas
=COUNTIF(N15:N31,1)+COUNTI
=COUNTIFS(N15:N31,">=3",N1
=COUNTIFS(N15:N31,">=6",N1
Does that answer your question?
Thomas