Menu
EXCEL COUNTA FUNCTION
Excel COUNTA Function Introduction
This function produces the number of cells which are not blank. Except for non-blank cells, the COUNTA function counts cells that include numbers, text, logical values, error values, and empty text (””).
Description of Excel COUNTA Function
Syntax:
=COUNTA (value1, [value2], …)
Parameter list:
- value1 might be an object, a cell reference, or a range.
- value2 – an item, cell number, or range (optional).
- There is indeed a limit of 255 arguments.
Step By Step Guide of COUNTA Function
In this example, the COUNTA method counts all values but apart from blank.
Key Points
The COUNTA function counts cells that contain any sort of data, including erroneous values and blank text (“”). For example, if a formula in the range returns an empty string, the COUNTA function counts that value. The COUNTA function doesn’t really count empty cells.
If you don’t need to count logical values, text, or error values (in other words, if you simply want to count cells that contain numbers), use the COUNT function.
Use the COUNTIF or COUNTIFS functions to count only cells that fulfil particular criteria.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
