CountIF Range
=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)
"Michael" wrote in message
news:58JDf.147890$WH.100840@dukeread01...
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
|