Counting Numbers With COUNT

Spreadsheets are full of numbers, but sometimes you just want to know how many there are. How many sales were recorded? How many test scores were entered?

The COUNT function answers exactly that question. It looks at a range of cells and tells you how many of them contain numbers.

Throughout this lesson you'll learn how COUNT works, what it ignores, and how to use it on real data. Let's start counting.

The COUNT function takes one or more ranges and returns the number of cells that hold a numeric value.

Its basic shape is simple:

• =COUNT(range)

For example, if cells A1 through A10 contain numbers, this formula returns how many of them actually have a number in them.

Imagine column A holds daily sales figures: 120, 95, 200, 150, 80 in cells A1 to A5.

Writing =COUNT(A1:A5) returns 5, because all five cells contain numbers.

COUNT does not add the numbers together. It simply tallies how many cells are numeric. The total of these sales would be a job for SUM instead.

What if some cells in your range are blank? COUNT simply skips them.

Say A1:A5 holds 120, (blank), 200, (blank), 80. The formula =COUNT(A1:A5) returns 3, because only three cells contain numbers.

This makes COUNT perfect for asking "how many entries do I actually have?" even when your column has gaps.

COUNT only cares about numbers. Any cell holding text is ignored.

Suppose A1:A5 contains 120, "N/A", 200, "pending", 80. The words are text, so =COUNT(A1:A5) returns 3.

This is useful when a column mixes real values with notes like "N/A" or "TBD". COUNT tells you how many true numbers you have.

Behind the scenes, spreadsheets store dates and times as numbers. A date like 1 Jan 2026 is really a serial number with formatting on top.

Because of this, COUNT does count cells that contain dates or times.

So if your range mixes plain numbers and dates, both get included in the total. Keep this in mind when a count comes out higher than you expected.

COUNT can take more than one range at a time. Just separate them with commas.

This is handy when your numbers live in two separate areas of the sheet.

• =COUNT(A1:A10, C1:C10)

This returns the combined count of numeric cells from both ranges added together.

The arguments to COUNT don't have to be ranges. You can pass individual cells or even typed-in values.

For example, =COUNT(A1, A5, 42) checks A1 and A5 and also counts the literal number 42.

In everyday work you'll mostly use ranges, but knowing this flexibility helps you read other people's formulas.

You run a small shop and log each day's revenue in column B, from B2 to B32. Some days the shop was closed, so those cells are blank.

To find out how many days you actually made sales, use:

• =COUNT(B2:B32)

The result tells you exactly how many days had a numeric revenue entry, ignoring the closed days automatically.

It's easy to mix up COUNT and SUM, so let's keep them straight:

• =SUM(A1:A10) adds the numbers together to give a total.
• =COUNT(A1:A10) tells you how many numbers there are.

If A1:A10 holds five values of 10 each, SUM returns 50 and COUNT returns 5. Different questions, different functions.

Good news: COUNT behaves identically in Microsoft Excel and Google Sheets. The same formula works in both tools with no changes.

Whether you type =COUNT(A1:A10) in Excel or in Sheets, you get the count of numeric cells in that range.

This consistency means the counting skills you build here transfer everywhere.

Time to test your understanding of COUNT.

You've learned how to tally numbers in a range. Key takeaways:

• =COUNT(range) returns how many cells contain numbers.
• It ignores blank cells and text values.
• It does count dates and times, since those are stored as numbers.
• You can pass multiple ranges separated by commas.
• COUNT counts; SUM totals. They answer different questions.

Next up: counting everything, not just numbers, with COUNTA.