COUNT and COUNTA functions in Google Sheets - Step-by-Step Guide

Introduction

These functions help you count how many cells have numbers or any data in a range. COUNT counts only numbers, while COUNTA counts all non-empty cells. This is useful when you want to know how many entries or values you have in a list.

When you want to count how many sales amounts are recorded in a column.

When you need to know how many people filled out a survey, regardless of answer type.

When you want to count how many cells in a list contain any data, including text and numbers.

When you want to count only the numeric values in a range, ignoring empty or text cells.

When you want to quickly check how many items are listed in a column without empty spaces.

Steps

Step 1: Click

- a blank cell where you want the count result

The cell is selected and ready for input

Step 2: Type

- the formula bar

The formula appears in the selected cell

💡 Start formulas with an equal sign (=)

Step 3: Type

- formula bar

Formula is ready to count numbers

💡 For counting numbers, type: =COUNT(A2:A10)

Step 4: Press

- Enter key

The cell shows how many numeric values are in the range A2 to A10

Step 5: Repeat

- in another blank cell

You can count all non-empty cells with: =COUNTA(A2:A10)

Step 6: Press

- Enter key

The cell shows how many cells have any data (numbers or text) in the range A2 to A10

Before vs After

Before

Column A has numbers in A2, A3, A5 and text in A4, A6, with some empty cells

After

Using =COUNT(A2:A6) shows 3 because only numbers count; using =COUNTA(A2:A6) shows 4 because all non-empty cells count

Settings Reference

Range selection

📍 Inside the parentheses of COUNT or COUNTA formula

Defines which cells to count

Default: No default, user must specify range

Common Mistakes

Using COUNT to count text entries

COUNT only counts numbers, so text cells are ignored

Use COUNTA to count all non-empty cells including text

Not starting formula with = sign

Without =, Google Sheets treats input as text, not a formula

Always start formulas with =, for example =COUNT(A2:A10)

Summary

COUNT counts only numeric cells in a range.

COUNTA counts all non-empty cells, including text and numbers.

Always specify the correct range inside the parentheses.