Count Number Of Blank Values/Character Values/Numeric Values In Excel

To count the values of text, numeric and blank cells in a range use the below formula.

Count ()-Counts the numeric values.

CountA ()-Counts the non-empty cells.

And COUNTA (A2:A15)-COUNT (A2:A15) returns the character values.




Capture

Hope this helped.

Share The Knowledge

Random Posts

Leave a Reply