Excel Counting non blank cells
I am having no luck trying to count my non blank cells in excel. I have
tried multiple formulas and I keep getting inaccurate data. Here is the
situation:
I am creating a Preventative Care list for my physicians (I have 4) I
created a list of all their patients that have received a letter re: Prev.
Care and I am inputting who needs a second letter and who has results.
Some results are negative, some are positive. I have the list set up in
alphabetical order on patients last name and then I have their physician
initials in the other column. I want to check to see what percentage of
each doctors patients have done their prev. care. I want to calculate this
separately. Unfortunately, the cells are no in order. I have tried
everything to my knowledge.
Help!
No comments:
Post a Comment