LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
JennLee
 
Posts: n/a
Default Need to Count number of occurrences and get percentage of total

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!!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 03:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"