COUNTA Function Explained
The COUNTA Function in Microsoft Excel counts the number of cells that contain a value or text string in a given range. It ignores empty cells, cells with errors, and cells containing text that looks like a number. It takes up to 255 arguments, and returns the number of non-blank cells.
COUNTA Function Syntax
COUNTA(value1, [value2], ...)
- value1: The first value or range of values to be counted.
- [value2]: (Optional) Additional values or ranges of values to be counted.