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")
--
Regards

Roger Govier


"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