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.
Analogy
"Think of this like counting coins in a jar. It ignores any buttons, paper clips, or receipts, counting only the coins (numbers)."
Syntax guide.
=COUNT(value1, [value2], ...)
Parameters
value1Required
The first cell reference, range, or value to count.
value2Optional
Additional items or ranges to count.
Interactive formula builder.
Fill in the input arguments below to construct your custom formula string. Copy it directly to paste into your Excel spreadsheets.
Generated Output
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 Gotchas
- If you have numbers formatted as text, COUNT will ignore them. Make sure your values are formatted as numbers.