Counts cells that are not blank in Excel
Counts how many values are in the list of arguments


Counts non-blank cells (Numbers and Text).


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).


= COUNTA(value1, [value2], …)


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:

Find the average of numbers in Excel


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.

Read More »
Counts cells with only Numbers in Excel


The COUNT function count of numbers within the reference list of arguments ignoring text & blank cells, =COUNT(A1:A10) will return 5 (only numeric).

Read More »
Count reference cells based on criteria in Excel


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.

Read More »
Count cells that are blank in Excel


The COUNTBLANK function returns the count of blank cells only ignoring number and text cells Like,=COUNTBLANK(A1:A10) will return 3 (ignoring value).

Read More »
To add multiple numbers in Excel


The SUM function returns a number after adding multiple numeric arguments together =SUM(5,10,15) the Excel add numbers together and returns 30.

Read More »
Count reference cells based on multiple criteria in Excel


The COUNTIFS function returns a count of numbers based on one or multiple given criterion based on dates, numbers, and text.

Read More »