Skip to Content

COUNTA

Counts how many values are in the list of arguments

Syntax

COUNTA(value1, [value2], ...)

Parameters

  • value1: Required. The first argument representing the values to count
  • value2: Optional. Additional arguments, up to 255

Example

=COUNTA(A1:A10)
Returns: NumberSince: Excel 2003