COUNTA function
Summary
Counts how many values are in the list of arguments
Syntax
COUNTA(value1, [value2], ...)
The COUNTA function syntax has the following arguments:
• value1 Required. The first argument representing the values that you want to count.
• value2, ... Optional. Additional arguments representing the values that you want to count, up to a maximum of 255 arguments.
• value1 Required. The first argument representing the values that you want to count.
• value2, ... Optional. Additional arguments representing the values that you want to count, up to a maximum of 255 arguments.
Example
=COUNTA(A2:A6)