Skip to main content
  1. Spreadsheet.com Support
  2. Functions
  3. Statistical functions

COUNTA

Returns a count of the number of values in a dataset.

Sample Usage

COUNTA(A1:A25,B1:B20)
COUNTA(1,2,3,4,5,C6:C20)

Syntax

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

  • value1 - The first number or range to consider when counting.
  • value2, .. - [OPTIONAL] Additional numbers or ranges to consider while counting.

Examples

COUNTA(A1:A25,B1:B20) counts the number of cells that contain values in cells A1:A25 and B1:B20.

 

Notes

  • All non-blank cells are included in the count.
  • The COUNTA function counts cells containing any type of information, including error values and empty text (""). 
  • If you want to count only cells that contain numbers, use the COUNT function.
  • COUNTA counts all numeric values in a dataset, including those which appear more than once. To count unique values, use COUNTUNIQUE.