How to Use COUNT/COUNTA in Google Sheets

By Tomosuke Hasegawa · Updated Oct 29, 2026 · Beginner · 5 min read · includes 2 free exercises

In short: COUNT counts only the numbers in a range. COUNTA counts every value, including text. The formulas are =COUNT(value1, [value2, ...]) and =COUNTA(value1, [value2, ...]).

What COUNT and COUNTA do

Both functions count cells, but they count different things. COUNT counts numeric values and ignores text. COUNTA counts all values, including text. Choosing the wrong one is the most common reason a count looks off.

Syntax

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

According to Google's COUNT page, COUNT counts only numeric values, ignores text, and counts every numeric occurrence, duplicates included. The COUNTA page says COUNTA counts all values, including repeated ones, text, zero-length strings and whitespace. To count only distinct values, use COUNTUNIQUE.

A step-by-step example

Here is a small stock list in cells A1:B6. The quantity for Book is empty, and the one for Mug is the text n/a.

AB
1ItemQty
2Pen3
3Book
4Cap5
5Mugn/a
6Tape2

To count the cells that hold a number:

=COUNT(B2:B6)

This returns 3: the values 3, 5 and 2. The empty cell and the text n/a are skipped.

To count every cell that holds a value:

=COUNTA(B2:B6)

This returns 4: the numbers 3, 5 and 2, plus the text n/a. The empty cell is not counted.

Which one should you use?

Common mistakes

Try it yourself

Use the stock list above (A1:B6). Type your formula into the box, starting with =, then press Check.

Exercise 1: Count the numbers

Write a formula that counts how many numbers are in B2:B6.

Hint: COUNT ignores text and empty cells.

Exercise 2: Count the filled cells

Write a formula that counts how many cells in B2:B6 hold any value, text included.

Hint: this is the function that ends in A.

What to learn next

Syntax and rules in this guide were checked against Google's COUNT/COUNTA help page. See all guides.