Excel COUNTA Function (Example + Video)
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.
=COUNTA(value1, [value2], …)
- 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.
- 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:
You May Also Like the Following Tutorials:
- 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.