Statistical

COUNTA function

Count non-empty. COUNTA works in Sheets with the usual arguments and results, on cells and on live data from the tools you connect.

Syntax

=COUNTA(value1, [value2, ...])
ArgumentUse
value1required, repeatable
value2optional, repeatable
required

Example

Count the non-empty cells, text included.

fx=COUNTA(A2:A7)
ABCDEF
1OrderCustomerRegionStatusAmountDate
2#1001Acme LtdNorthPaid12002026-01-14
3#1002Blue FoxSouthOpen4502026-01-20
4#1003Acme LtdNorthPaid9802026-02-03
5#1004Cedar & CoEastOverdue23002026-02-11
6#1005Blue FoxSouthPaid6102026-03-02
7#1006Delta BVWestOpen17502026-03-09
86

Result computed by the Sheets formula engine.

On live data

In Sheets, COUNTA sits next to live data from a connected tool: =data.orders.sum(total) totals a table, =list.orders(customer) spills a column's distinct values, and a linked table column such as table.orders[Total] is a range any function accepts.

See the integrations

Try it in a free calculator

Find duplicates in a listPaste a list to flag every duplicate, count the distinct values and list the ones that repeat, with the COUNTIF and UNIQUE formulas that do it in any spreadsheet..

More statistical functions

AVERAGEMean of valuesAVERAGEIFMean where one criterion matchesAVERAGEIFSConditional meanCOUNTCount numbersCOUNTIFCount where one criterion matchesCOUNTIFSConditional countMAXMaximum valueMAXIFSLargest value where all criteria matchMEDIANMiddle valueMINMinimum valueMINIFSSmallest value where all criteria matchPERCENTILE.INCThe k-th percentile, k from 0 to 1

All 147 statistical functions →

Spreadsheet formulas on live business data

Sheets evaluates 491 spreadsheet functions, on cells and on data read live from your tools.

See the integrations