Returns the count of non-blank cells.
= COUNTA(value1, [value2], …)
- value1: A value, a cell reference, a range of cells, or an array.
- [value2]: A value, a cell reference, a range of cells, or an array.
- It will count the cell which has a (text, number, formula, a cell with a formula resulting in an empty cell, symbol, and error).
Written by Puneet for Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel for Mac