Hip, Hip, COUNTA( ) !

I was ready to toast this function at work today.

Presented with a list of encounters by physician, I wanted to know how many cells in the array were blank. This meant that we did not have data for those physicians.

Rather than resort my data and manually count the blanks, COUNTA( ) presented me with the number of cells that had a non-blank value. After using a COUNT( ) function to get the total number of cells, I could easily back into the number of blank cells.


Careful, though! Cells with a 0 or a non-numeric entry will be counted as non-blank. Notice in the demonstration how even a “TBD” cell was included.

Still, though, a great function I just learned today! Always more to learn in Excel. 


Subscribe to my mailing list.

Leave a Reply

%d bloggers like this: