COUNT and COUNTA functions in Excel - Step-by-Step Guide

Introduction

COUNT and COUNTA are Excel functions that help you count cells. COUNT counts only numbers, while COUNTA counts all non-empty cells. They solve the problem of quickly finding how many entries or numbers are in a list.

When you want to know how many numbers are in a list of sales figures.

When you need to count how many people filled out a survey, including text answers.

When you want to find out how many cells in a range are not empty, regardless of content type.

When you want to count only numeric data like prices or quantities in a column.

When you want to check how many responses you received in a feedback form that includes text and numbers.

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 cell and formula bar

💡 Start with =COUNT( to count numbers only

Step 3: Select

- the range of cells you want to count, for example A1:A10

The range is highlighted and appears inside the parentheses

Step 4: Type

- the formula bar

The formula looks like =COUNT(A1:A10)

💡 Press Enter to see the count of numeric cells

Step 5: Repeat

- steps 1 to 4 but use =COUNTA(A1:A10) to count all non-empty cells

The cell shows how many cells have any content, numbers or text

Before vs After

Before

Column A has 10 cells: 5 numbers, 3 text entries, 2 empty cells

After

Using =COUNT(A1:A10) shows 5; using =COUNTA(A1:A10) shows 8

Settings Reference

Range selection

📍 Inside the parentheses of COUNT or COUNTA formula

Defines which cells to count

Default: No default, user must specify

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

Including empty cells in the range but expecting them to count

Both COUNT and COUNTA ignore empty cells

Make sure the range only includes cells you want to count or understand empty cells won't add to the count

Summary

COUNT counts only numeric cells in a range.

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

Choose COUNT for numbers only and COUNTA for any content.