Need to Count number of occurrences and get percentage of total

[Guest]

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!!

 

[Bob Phillips]

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

and

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

--

HTH

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

 

[Guest]

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.

 

[Bob Phillips]

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>