CountIF Range
 

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

CountIF Range
 

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

CountIF Range
 

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

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

CountIF Range
 

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
--
Gary's Student


"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