Excel COUNTA Function

Excel COUNTA Function

Related Functions


Count the number of non-blank cells

Return value 

A number representing non-blank cells.


=COUNTA (value1, [value2], …)


  • value1 – An item, cell reference, or range.
  • value2 – [optional] An item, cell reference, or range.

Usage notes 

Use the COUNTA function to count cells that contain numbers, text, logical values, error values, and empty text (“”). COUNTA does not count empty cells.

COUNTA will also count items. For example, =COUNTA(“a”,1,2,3,””) returns 5.

Use COUNT to count numeric values only.

Count can handle up to 255 values.

0 votes. 0 / 5

Excel - Excel Functions - Excel Formulas