Rational
Counts non-blank cells (Numbers and Text).
Description
The Excel COUNTA function returns the count of numbers and text within the reference list of arguments ignoring blank cells.
For example, if A1:A10 contains three empty cells and the remaining area is filled with any value, to count values in the range A1:A10; =COUNTA(A1:A10), the formula will return 7 (ignoring blank).
Syntax
= COUNTA(value1, [value2], …)
Parameters
value1 – First range or array of values
value2 [optional] – Second range or array of values.
The COUNTA function can accommodate up to 255 numbers as an argument.
Return Value
An Integer indicating counts of non-blank cells.
Key Notes
- The Excel COUNTA function counts numerical, dates, text, logical, error values in each range (value).
- The user can use the COUNT function to count only numerical numbers.
- A cell with any value including zero or space is counted.
Keep Reading Similar Functions:
COUNT
The COUNT function count of numbers within the reference list of arguments ignoring text & blank cells, =COUNT(A1:A10) will return 5 (only numeric).
COUNTIFS
The COUNTIFS function returns a count of numbers based on one or multiple given criterion based on dates, numbers, and text.
COUNTBLANK
The COUNTBLANK function returns the count of blank cells only ignoring number and text cells Like,=COUNTBLANK(A1:A10) will return 3 (ignoring value).
COUNTIF
The COUNTIF function returns a count of number based on given criteria like =COUNTIF(A1:A5,”>5″) that count numbers in the list >5 and returns 3.
SUM
The SUM function returns a number after adding multiple numeric arguments together =SUM(5,10,15) the Excel add numbers together and returns 30.
AVERAGE
The AVERAGE function returns an average of numbers positioned in one or multiple ranges, =AVERAGE(5,15,30) add numbers and divide by 3, and returns 16.67.
