How it works.
The COUNT function is used to get the number of entries in a number field in a range or array of numbers. It ignores empty cells, logical values, text, or error values.
💡 In simple terms.
Counts how many cells in a range contain actual numbers, completely ignoring text or blank cells.
"Think of this like counting coins in a jar. It ignores any buttons, paper clips, or receipts, counting only the coins (numbers)."
Formula syntax.
Standard Excel Notation=COUNT(value1, [value2], ...)[like_this] are optional; all other arguments are required.Formula arguments.
Every parameter accepted by the COUNT function is detailed below.
The first cell reference, range, or value to count.
Example value:B2:B6Additional items or ranges to count.
Simple example.
Step-by-Step ScenarioCount Numeric Entries
Count how many days have numeric attendance logged, ignoring "Absent" text entries.
| Day | Attendance Count | Status | Days Logged | |
|---|---|---|---|---|
| Monday | 24 | Done | — | — |
| Tuesday | Absent | Done | — | — |
| Wednesday | 26 | Done | — | — |
=COUNT(B2:B6)Evaluates COUNT over the sample table cells, placing the verified output in cell D2.
Formula generator.
Full Generator WizardCustomize the argument fields below to generate a tailored COUNT formula ready to paste directly into your worksheet.
=COUNT()Expected result behavior.
Returns number 5 based on sample evaluation criteria and active cell references.
Best Practices
- To count all non-empty cells (including text and numbers), use the COUNTA function instead.
- To count cells based on specific conditions, use COUNTIF or COUNTIFS.
Common Mistakes
- If you have numbers formatted as text, COUNT will ignore them. Make sure your values are formatted as numbers.
Platform & version compatibility.
Verified platform compatibility matrix based on actual spreadsheet calculation engine specifications.
Core standard function supported across all modern and legacy Microsoft Excel versions (365, 2021, 2019, 2016, 2013, 2010), as well as Excel for the Web and Mac.
100% compatible with Google Sheets. Uses identical argument order, data types, and standard calculation logic.
Frequently asked questions.
Technical Q&ACan I use COUNT across different worksheets in Excel?↓
Yes. You can reference cells located on other sheets by including the sheet name followed by an exclamation mark, for example: =COUNT(Sheet2!A2:A10). If the sheet name contains spaces, enclose it in single quotes: ='Q1 Report'!A2:A10.
What is the most common reason for errors in COUNT?↓
If you have numbers formatted as text, COUNT will ignore them. Make sure your values are formatted as numbers.
Does COUNT work identically in Google Sheets?↓
Yes, COUNT is supported in both Microsoft Excel and Google Sheets with standard evaluation behavior.