CountIF Range

M

Michael

Hi Folks - Here's my scenario:

I have data like this ....

Student Sessions Attended
A 12
B 10
C 5
D 3
E 14
F 8

I want to be able to provide the following counts:

* The number of students over 12 sessions
* The number of students between 8 and 12 sessions
* The number of students less than 8 sessions


Do-able? Thanks.

Michael
 
A

Ashish Mathur

Hi,

try the following array formula (Ctrl+Shift+Enter)

=sum(if(range>12,1,0))
=sum(if(range<8,1,0))

Regards,

Ashish Mathur
 
R

Roger Govier

Hi Michael

Greater than 12 =COUNTIF(B:B,">12")
Between 8 and 12 =COUNTIF(B:B,">8")-COUNTIF(B:B,">12")
Less than 8 =COUNTIF(B:B,"<8")
 
B

Bob Phillips

=COUNTIF(A:A,">12")

=COUNTIF(A:A,">=8")-COUNTIF(A:A,">12")

=COUNTIF(A:A,"<8")

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
G

Gary''s Student

Only one column is needed, say column B
=countif(B1:B6,">12") in C1 yields the number greater than 12
=countif(B1:B6,"<8") in D1 yields the number less than 8
=count(B1:B6)-C1-D1 yields the number in the middle
 
Top