Need to Count number of occurrences and get percentage of total

J

JennLee

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

Bob Phillips

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

and

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

--

HTH

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

JennLee

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.
 
B

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>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count the number of dates less than a given date 1
I need the percentage of objects used in a drop-down box 2
How can count the number of cells that fulfill certain criteria in other cells 2
Need help with sorting and moving to worksheets 1
count the number of rows with entries greater than zero 1
Count of Patients by City within date range 1
count based on single number 13
Count if dates meet certain criteria 10

Top