Thread: CountIF Range
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default 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