Excel COUNTA function

Function              COUNTA

Description        Excel COUNTA function counts the number of cells that are not empty in a range.

Syntax  COUNTA(value1, [value2], …)

value1  An item, cell reference, or range.

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

Example:

Usage Notes:

• COUNTA function is used to count cells that contain numbers, text, logical values, error values, and empty text (“”). It does not count empty cells.

Related Video Tutorials: