COUNT Function
COUNT returns the count of cells containing numbers in a range.
Syntax
Parameters
| Parameter | Description | Required |
|---|---|---|
| value1 | The first item, cell reference, or range to count. | Required |
| value2 | Optional additional items, cell references, or ranges to count. | Optional |
Basic Example
Count the number of numeric entries in a range
=COUNT(A1:A10)Counts how many cells in A1:A10 contain numbers, ignoring text and blank cells.
Advanced Examples
Example 1: Count across multiple ranges
Data analysisCount numeric values across multiple non-contiguous ranges
=COUNT(A1:A10, C1:C10, E1:E10)Example 2: Count with criteria using COUNTIF
Filtered countingFor conditional counting, use COUNTIF or COUNTIFS instead
=COUNTIF(A1:A10, ">50")How COUNT Works
COUNT scans each cell in the specified range and counts only those containing numeric values. It ignores empty cells, text, logical values (TRUE/FALSE), and error values.
Important Notes & Limitations
COUNT only counts cells with numeric values — text, blanks, and logical values are ignored.
Use COUNTA to count all non-empty cells, or COUNTIF/COUNTIFS for conditional counting.
Common Errors & Fixes
0No numeric values found in the rangeFix: Check your data range or use COUNTA if you want to count all non-empty cells.
Download Practice File
COUNT
countPractice COUNT with Real Data
Download a sample CSV file with pre-populated data and practice exercises for the COUNT function. Works in both Excel and Google Sheets.
File format: CSV (comma-separated values) - opens in Excel, Google Sheets, and all spreadsheet apps
Related Tutorials
Convert Text to Number in Excel and Google Sheets
Convert text to number in Excel and Google Sheets with VALUE, multiplication and Paste Special. Handles currency symbols, hidden spaces and #VALUE! errors.
COUNTIF with Wildcard: Count Cells by Text Pattern
COUNTIF with wildcard patterns counts cells by prefix, suffix or length. Learn the * and ? rules, how to escape a literal asterisk, and where numbers fail.
How to Use Excel Formulas: From the First Equals Sign to a Real Report
Learn how to use Excel formulas step by step: the equals sign, cell references, SUM, IF and VLOOKUP, plus the errors beginners hit and how to fix them.