fx =COUNTA(A1:A100)ABCJan Score8782.3Feb Score92Mar Score78
📈 Statistical

COUNTA Formula for Statistical

Count non-empty cells in a range. Copy-paste ready for Excel, Google Sheets, and Airtable.

=COUNTA(A1:A100)
When you need this: When you have a survey (A1:A100) and need to count how many people responded (non-empty cells = responses).

How it works

  1. 1COUNTA counts all non-empty cells in a range (A1:A100).
  2. 2Counts text, numbers, dates, even formulas — anything that isn't blank.
  3. 3Perfect for completion tracking or response rates.

Variations

Count only text entries
=COUNTIF(A1:A100,"<>"&"")
Count blank cells
=COUNTBLANK(A1:A100)

Related Formulas

AVERAGE — Calculate the average of a rangeStatisticalCOUNTIF — Count cells that meet a conditionStatisticalCOUNTIFS — Count cells meeting multiple conditionsStatisticalMAX / MIN — Find the largest or smallest value in a rangeStatistical

Need a formula that's not here?

Generate custom formula →