Use Excel COUNTA Function to count non-blank cells. In simple words, COUNTA Function can count the cell which has any type of value in it.
COUNTA(value1, [value2], …)
In the below example, I have used COUNTA Function to count cells from range A1:A11.
There are total 11 cells in the range and function has return 10. I have one blank cell in the range which is ignored by the function. In rest of the cells, I have numbers, text, logical value and a symbol.
To learn more about Excel AVERAGE Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.