HELP !!
I have a list from which I need to count the number of occurrences of a cell
value greater than 10 and the number of occurrences of a cell value less than
10 then return a percentage of the total count of rows.
I have a formula =COUNTA(A7:A222) that returns to me the number of
patients, but I need to get the above info of the therapy visits based on
greater than 10 and less than 10. Clear as mud?!!

Ex: As below, it would be 4 patients with less than 10 therapy visits and 3
patients with greater than 10 therapy visits -

Jennifer 8
Tommy 9
Sally 15
John 8
Nick 12
Jessy 12
Alex 7

Any help will be greatly appreciated!!

=COUNTIF(B7:B222,"10")

and

=COUNTIF(B7:B222,"<10")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"JennLee" wrote in message
...
HELP !!
I have a list from which I need to count the number of occurrences of a
cell
value greater than 10 and the number of occurrences of a cell value less
than
10 then return a percentage of the total count of rows.
I have a formula =COUNTA(A7:A222) that returns to me the number of
patients, but I need to get the above info of the therapy visits based on
greater than 10 and less than 10. Clear as mud?!!

Ex: As below, it would be 4 patients with less than 10 therapy visits and
3
patients with greater than 10 therapy visits -

Jennifer 8
Tommy 9
Sally 15
John 8
Nick 12
Jessy 12
Alex 7

Any help will be greatly appreciated!!

Thanks - that's perfect! But I also need to include the ones with the VALUE
of 10 in the 10 count! In other words I need "10 AND Greater than 10" Is
it possible?
Thanks again in advance.
--
Jennifer Lee
IS Coordinator/App Support


"Bob Phillips" wrote:

=COUNTIF(B7:B222,"10")

and

=COUNTIF(B7:B222,"<10")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"JennLee" wrote in message
...
HELP !!
I have a list from which I need to count the number of occurrences of a
cell
value greater than 10 and the number of occurrences of a cell value less
than
10 then return a percentage of the total count of rows.
I have a formula =COUNTA(A7:A222) that returns to me the number of
patients, but I need to get the above info of the therapy visits based on
greater than 10 and less than 10. Clear as mud?!!

Ex: As below, it would be 4 patients with less than 10 therapy visits and
3
patients with greater than 10 therapy visits -

Jennifer 8
Tommy 9
Sally 15
John 8
Nick 12
Jessy 12
Alex 7

Any help will be greatly appreciated!!

Sorry, should have realised that

=COUNTIF(B7:B222,"=10")

Bob

BTW - how can it be perfect if it doesn't do part of it? <bg


"JennLee" wrote in message
...
Thanks - that's perfect! But I also need to include the ones with the
VALUE
of 10 in the 10 count! In other words I need "10 AND Greater than 10"
Is
it possible?
Thanks again in advance.
--
Jennifer Lee
IS Coordinator/App Support


"Bob Phillips" wrote:

=COUNTIF(B7:B222,"10")

and

=COUNTIF(B7:B222,"<10")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"JennLee" wrote in message
...
HELP !!
I have a list from which I need to count the number of occurrences of
a
cell
value greater than 10 and the number of occurrences of a cell value
less
than
10 then return a percentage of the total count of rows.
I have a formula =COUNTA(A7:A222) that returns to me the number of
patients, but I need to get the above info of the therapy visits based
on
greater than 10 and less than 10. Clear as mud?!!

Ex: As below, it would be 4 patients with less than 10 therapy visits
and
3
patients with greater than 10 therapy visits -

Jennifer 8
Tommy 9
Sally 15
John 8
Nick 12
Jessy 12
Alex 7

Any help will be greatly appreciated!!