Hi,

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

=sum(if(range12,1,0))
=sum(if(range<8,1,0))

Regards,

Ashish Mathur

"Michael" wrote:

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