When to use Excel COUNTA Function
COUNTA function can be used when you want to count all the cells in a range that are not empty.
What it Returns
It returns a number that represents the number of cells that are not empty.
Syntax
=COUNTA(value1, [value2], …)
Input Arguments
value1 – the first item, cell reference, or range within which you want to count the number of cells that are not empty. [value2], … – (optional) up to 255 additional items, cell references, or ranges within which you want to count the number of cells that are not empty.
Additional Notes
Counts all the cells that are not empty If cells that contain any type of information including error values, then it is counted by COUNTA. If a formula returns an empty cell, that is counted by COUNTA.
Excel COUNTA Function – Live Example
Excel COUNTA Function – Video Tutorial
Related Excel Functions:
Excel COUNT Function. Excel COUNTBLANK Function. Excel COUNTIF Function. Excel COUNTIFS Function.
Count Unique Values in Excel Using COUNTIF Function. Using Multiple Criteria in Excel COUNTIF and COUNTIFS Function How to Count Cells that Contain Text Strings.
