Skip to content
FormulaCraft

COUNTA

COUNTA counts every non-blank cell, unlike COUNT which only counts numbers. It is the right tool for tallying responses, names, or any mix of text and numbers.

Excel
=COUNTA(A2:A4)
Google Sheets
=COUNTA(A2:A4)
✓

Verified example

Computed by a real spreadsheet engine on the sample data below.

Name
Ann
Bob

=COUNTA(A2:A4)→2

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Runs server-side · free · no signup

How it works

  1. 1A2:A4 is the range to inspect.
  2. 2Blank cells are skipped; everything else is counted.
  3. 3Here Ann and Bob are counted (2); the empty cell is ignored.

Need a version for your data?

Try: “Count how many names are filled in, ignoring blanks”

Related

COUNTBLANKMODEAVERAGEA

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: