If you want to know how many cells in a range hold a number, the COUNT function in Google Sheets gives you the answer in a single step. It only counts numeric cells. Text, blank cells, and errors get skipped.
In this article, I’ll show you how to use COUNT to tally numeric cells, count across two ranges, and count dates. I’ll also cover how to spot missing entries with it and how to combine COUNT with FILTER for a conditional count.
COUNT Function Syntax in Google Sheets
The COUNT function counts how many cells in one or more ranges contain numeric values.
=COUNT(value1, [value2, ...])
- value1 is the first value or range you want to check.
- value2, … are optional extra values or ranges. You can pass as many as you need.
Only numeric cells are counted. Text, blanks, and error values are ignored. This is the key difference between COUNT and its siblings like COUNTA, which counts any non-empty cell, and COUNTBLANK, which counts only the empty ones.
When to Use COUNT Function
- Count how many scores, prices, or amounts are filled in inside a column.
- Count valid date entries, since dates are stored as numbers under the hood.
- Spot missing entries by counting the numeric cells and comparing against your total row count.
- Combine numeric ranges from multiple columns into one count.
- Wrap a FILTER inside COUNT to count only the numeric rows that meet a condition.
Example 1: COUNT Only Counts Numeric Cells
Let’s start with the most common job, counting how many cells in a column hold a real number.
Below is the dataset. Column A has the student name and column B has the score. A few rows have text labels like “Absent” or “N/A” where a number would normally go.
I want to know how many students have a numeric score recorded.
Here is the formula:
=COUNT(B2:B7)
COUNT walks through every cell in B2:B7 and only tallies the numeric ones. Adam, Kevin, Jenna, and Rohan have real numbers, so the count comes to 4.
The text values “Absent” and “N/A” get skipped. This is the behavior to remember. COUNT is strictly for numbers.
Pro Tip: If you want to count every non-empty cell, including text, use COUNTA. If you want to count blank cells, use COUNTBLANK. COUNT is only for numbers.
Example 2: Count Across Two Non-Adjacent Columns
COUNT accepts more than one range, so you can tally numeric cells from separate columns in a single shot.
Below is the dataset. Column A has the name, columns B and D hold quiz scores for Q1 and Q2, and column C has some text notes in between.
I want a single count of how many quiz scores are filled in across both Q1 and Q2 combined.
Here is the formula:
=COUNT(B2:B6, D2:D6)
Both ranges go to COUNT as separate arguments, and it adds up the numeric cells across both. Q1 has four numeric scores and Q2 also has four, so the total is 8.
The Notes column in between gets ignored. COUNT only looks at the ranges you explicitly pass it.
Example 3: COUNT Treats Dates as Numbers
Dates in Google Sheets are stored as numbers under the hood, so COUNT picks them up just like any other numeric value.
Below is the dataset. Column A has the customer name and column B has the signup date. A couple of rows have text labels like “Pending” or “Unknown” instead of a real date.
I want a count of how many customers have a valid date in the signup column.
Here is the formula:
=COUNT(B2:B7)
The four customers with real dates get counted, so the result is 4. The “Pending” and “Unknown” rows are text, so COUNT skips them.
This comes in handy when you want to verify that a date column is fully populated before running date-based reports.
Example 4: Use COUNT to Spot Missing Entries
When a column is supposed to have numbers in every row, COUNT tells you in one shot how many were actually entered.
Below is the dataset. Column A has the sales rep name and column B has their target. Two of the cells are blank because those reps haven’t entered a target yet.
I want to know how many reps have entered a target so I can follow up with the ones who haven’t.
Here is the formula:
=COUNT(B2:B7)
Four reps have a number in the target column, so the count is 4. The two blank cells get skipped because they hold no value at all.
Six reps sit in the list but only four have targets, so two need a follow-up. A quick subtract gets you the missing count.
Example 5: COUNT Inside a FILTER Wrapper
For a conditional count, you can wrap a FILTER inside COUNT and tally only the numbers that match a rule.
Below is the dataset. Column A has the region and column B has the sale amount for each row.
I want to count how many sale entries belong to the East region only.
Here is the formula:
=COUNT(FILTER(B2:B7, A2:A7="East"))
FILTER first returns just the sale amounts for the East rows. COUNT then tallies those numbers.
Three East rows make it through, with values 100, 300, and 250, so the count is 3. The West and North rows get dropped by FILTER before COUNT ever sees them.
This pattern works well when you need a conditional count of numeric values without writing a separate COUNTIF formula. The SUM function works the same way with FILTER if you need a conditional total instead of a count.
Tips & Common Mistakes
- COUNT only counts numbers, not text. This trips people up most often. If you want to count every non-empty cell (text and numbers alike), use COUNTUNIQUE for distinct entries, or COUNTA when you want the total non-empty count.
- Empty cells and empty strings don’t count. A cell that looks blank but holds “” from a formula is treated the same way as a fully empty cell. COUNT skips both. If you need to count formula-produced empty strings differently, you’ll need a more specific check.
- Errors break the count. If any cell in your range holds an error like #N/A or #DIV/0!, COUNT will return that error too. Wrap problem cells with IFERROR before running COUNT on the range, or fix the source error first.
COUNT is the function to use when you need to know how many numeric values sit inside one or more ranges.
You’ve now seen it skipping text, working across two columns, counting dates, spotting missing entries, and pulling a conditional count via FILTER. Use COUNT whenever the question is “how many numbers”.
List of All Google Sheets Functions
Related Google Sheets Functions / Articles: