Excel non-empty cell counting

Question

I had no luck trying to count my non-empty cells in excel. I tried several formulas and I keep getting inaccurate data. Here is the situation:

I create a list of preventive services for my doctors (I have 4). I created a list of all my patients who received the letter re: Prev. Leaving, and I introduce who needs a second letter and who has results. Some results are negative, some are positive. I have a list created in alphabetical order by the name of the patients, and then I have the initials of their doctors in another column. I want to check what percentage of all doctoral doctors did their previews. care. I want to calculate this separately. Unfortunately, the cells are out of order. I have tried everything that I know.

Help!

Answer 1

This will give you the number of empty cells you have. You can subtract this from the total number of cells in your column, or you can use it directly to calculate your percentage as (1 - x), where x is the percentage of empty cells.

=COUNTBLANK(<your column>) 

eg:

  =COUNTBLANK(A1:A10) 

Answer 2

If it is not immediately clear how to calculate the total number of cells in a range, this formula should help explain, fully answering the original question. It works with ranges that also contain more than 1 column.

=ROWS(range)*COLUMNS(range)-COUNTBLANK(range)

Answer 3

You can try something like:

=IF(LEN(A1) > 0, 1, 0)

Then you can summarize this column or do any other calculations you need.

Answer 4

=COUNTIF(range,"<>"&"") will count all cells that do not have a value equivalent to "" , so basically everything that is not empty.