software

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 sessionsDo-able? Thanks.

Michael

Hi,

try the following array formula (Ctrl Shift Enter)

=sum(if(rangegt;12,1,0))
=sum(if(rangelt;8,1,0))

Regards,

Ashish Mathur

quot;Michaelquot; wrote:

gt; Hi Folks - Here's my scenario:
gt;
gt; I have data like this ....
gt;
gt; Student Sessions Attended
gt; A 12
gt; B 10
gt; C 5
gt; D 3
gt; E 14
gt; F 8
gt;
gt; I want to be able to provide the following counts:
gt;
gt; * The number of students over 12 sessions
gt; * The number of students between 8 and 12 sessions
gt; * The number of students less than 8 sessions
gt;
gt;
gt; Do-able? Thanks.
gt;
gt; Michael
gt;
gt;
gt;
gt;

Hi Michael

Greater than 12 =COUNTIF(B:B,quot;gt;12quot;)
Between 8 and 12 =COUNTIF(B:B,quot;gt;8quot;)-COUNTIF(B:B,quot;gt;12quot;)
Less than 8 =COUNTIF(B:B,quot;lt;8quot;)
--
Regards

Roger Govierquot;Michaelquot; gt; wrote in message
news:58JDf.147890$WH.100840@dukeread01...
gt; Hi Folks - Here's my scenario:
gt;
gt; I have data like this ....
gt;
gt; Student Sessions Attended
gt; A 12
gt; B 10
gt; C 5
gt; D 3
gt; E 14
gt; F 8
gt;
gt; I want to be able to provide the following counts:
gt;
gt; * The number of students over 12 sessions
gt; * The number of students between 8 and 12 sessions
gt; * The number of students less than 8 sessions
gt;
gt;
gt; Do-able? Thanks.
gt;
gt; Michael
gt;
gt;
gt;
=COUNTIF(A:A,quot;gt;12quot;)

=COUNTIF(A:A,quot;gt;=8quot;)-COUNTIF(A:A,quot;gt;12quot;)

=COUNTIF(A:A,quot;lt;8quot;)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;Michaelquot; gt; wrote in message
news:58JDf.147890$WH.100840@dukeread01...
gt; Hi Folks - Here's my scenario:
gt;
gt; I have data like this ....
gt;
gt; Student Sessions Attended
gt; A 12
gt; B 10
gt; C 5
gt; D 3
gt; E 14
gt; F 8
gt;
gt; I want to be able to provide the following counts:
gt;
gt; * The number of students over 12 sessions
gt; * The number of students between 8 and 12 sessions
gt; * The number of students less than 8 sessions
gt;
gt;
gt; Do-able? Thanks.
gt;
gt; Michael
gt;
gt;
gt;
Only one column is needed, say column B
=countif(B1:B6,quot;gt;12quot;) in C1 yields the number greater than 12
=countif(B1:B6,quot;lt;8quot;) in D1 yields the number less than 8
=count(B1:B6)-C1-D1 yields the number in the middle
--
Gary's Studentquot;Michaelquot; wrote:

gt; Hi Folks - Here's my scenario:
gt;
gt; I have data like this ....
gt;
gt; Student Sessions Attended
gt; A 12
gt; B 10
gt; C 5
gt; D 3
gt; E 14
gt; F 8
gt;
gt; I want to be able to provide the following counts:
gt;
gt; * The number of students over 12 sessions
gt; * The number of students between 8 and 12 sessions
gt; * The number of students less than 8 sessions
gt;
gt;
gt; Do-able? Thanks.
gt;
gt; Michael
gt;
gt;
gt;
gt;