Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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!! |