Statistical
COUNT Function in Excel
Counts the number of cells that contain numbers.
Syntax
- =COUNT(value1, [value2], ...)
Arguments
- value1 (required): First value or range to count
- value2 (optional): Additional values or ranges
Examples
- =COUNT(A1:A100) - Count numeric cells in range - Result: Number count
- =COUNT(A:A, B:B) - Count numbers in multiple columns - Result: Total count
Excel COUNT function documentation
- COUNT is a Statistical function that counts cells containing numbers, dates, or numeric text.
- Syntax: =COUNT(value1, [value2], …). Does not count blank cells or pure text.
- Pair with [COUNTA](/functions/counta/) for all non-empty cells and [COUNTBLANK](/functions/countblank/) for empties.
- For conditional counts use [COUNTIF](/functions/countif/) or [COUNTIFS](/functions/countifs/).
COUNT vs COUNTA vs COUNTBLANK
- COUNT — numbers only (including dates stored as serial numbers).
- COUNTA — any non-empty cell: text, numbers, errors, formulas returning "".
- COUNTBLANK — truly empty cells only.
- Audit rule: COUNT + COUNTA + careful review of "" formulas ≈ total rows in simple lists.
Step-by-step: count numeric entries in a survey column
- Step 1 — Responses in column D may mix numbers and text comments.
- Step 2 — =COUNT(D2:D200) counts only numeric responses.
- Step 3 — =COUNTA(D2:D200) counts any filled response.
- Step 4 — Compare the two to see how many text vs numeric answers exist.
- Step 5 — For "how many East region rows" use =COUNTIFS(region, "East", amount, ">0").
COUNT vs COUNTIF vs COUNTIFS
- COUNT — no criteria; numeric cells only.
- COUNTIF — one condition such as ">100" or "=Closed".
- COUNTIFS — multiple AND conditions across columns.
- Compare: [COUNTIF vs COUNTIFS](/compare/countif-vs-countifs/) · [COUNTIF function](/functions/countif/).
Worked examples to copy
- Numeric responses: =COUNT(B2:B500).
- Count with threshold: =COUNTIF(B:B, ">0") counts positive numbers (different from COUNT).
- Progress tracker: =COUNTA(C:C)-1 minus header row for filled forms.
- Validation: =COUNT(E:E)=COUNTIF(E:E, ">=0") when all entries should be numbers.
People also ask
- Does COUNT count dates? — Yes. Dates are stored as numbers in Excel.
- Does COUNT count blank cells? — No.
- COUNT vs COUNTA? — COUNT is numbers only; COUNTA is any non-empty cell.
- Why COUNT lower than expected? — Text that looks like numbers is not counted.
Common errors
- Only counts numbers, not text
- Dates and times are counted (they're numbers)
Use cases
- Data validation
- Completeness checking
- Numeric data analysis
Frequently asked questions
- What is the difference between COUNT and COUNTA? COUNT counts only numeric cells (including dates). COUNTA counts all non-empty cells (numbers, text, errors, logical values). =COUNT(1,"text",TRUE)=1, =COUNTA(1,"text",TRUE)=3.
- Does COUNT include dates and times? Yes! Dates and times are stored as numbers in Excel, so COUNT includes them. To count only 'regular' numbers, you'd need a more complex formula.
- How do I count blank cells? Use COUNTBLANK: =COUNTBLANK(A1:A100) counts empty cells. Or calculate: =ROWS(A1:A100)-COUNTA(A1:A100) for blanks in a column.
- Why does COUNT return 0 for my data? COUNT only counts numbers. If your data is text (even if it looks like numbers), COUNT returns 0. Check with ISNUMBER or look for green triangles indicating text-numbers.
- Can COUNT count across multiple sheets? Yes, use 3D reference: =COUNT(Sheet1:Sheet12!A1) counts numeric values in A1 across sheets Sheet1 through Sheet12.
Editorial review
- Reviewed by Excel.Directory Editorial Team. Updated May 2026.
When to use COUNT
- Data validation — common Statistical scenario for COUNT.
- Completeness checking — common Statistical scenario for COUNT.
- Numeric data analysis — common Statistical scenario for COUNT.
COUNT in the Statistical category
- Browse all Statistical functions at /categories/statistical/ for related formulas.
- COUNT syntax: =COUNT(value1, [value2], ...)
- value1 (required): First value or range to count
- value2 (optional): Additional values or ranges
- Confirm COUNT arguments match the syntax shown above before filling down.
- Lock table and range references with $ when copying formulas across rows or sheets.
Formula checklist before you copy down
- Confirm COUNT arguments match the syntax shown above before filling down.
- Lock table and range references with $ when copying formulas across rows or sheets.
- If results look wrong, check for text stored as numbers and invisible spaces with TRIM.
- Spot-check three known input rows manually against expected output.
Related Excel functions
- COUNTA (/functions/counta/): Counts the number of cells that are not empty.
- COUNTBLANK (/functions/countblank/): Counts the number of empty cells in a specified range.
- COUNTIF (/functions/countif/): Counts the number of cells that meet a criterion.
- COUNTIFS (/functions/countifs/): Counts cells that meet multiple criteria across multiple ranges.
Errors to watch for
- Only counts numbers, not text — review causes on linked error pages in the directory.
- Dates and times are counted (they're numbers) — review causes on linked error pages in the directory.
Copy-paste audit workflow
- Enter COUNT on three test rows with known expected output documented on a QA tab.
- Fill down only after absolute references are locked on lookup tables and rate tables.
- Compare against manual calculation or a calculator for financial and statistical functions.
- Search this directory for comparison guides when choosing between similar functions in the same category.
COUNT worked examples to copy
- =COUNT(A1:A100) — Count numeric cells in range. Expected result: Number count.
- =COUNT(A:A, B:B) — Count numbers in multiple columns. Expected result: Total count.
COUNT reference summary for crawlers and offline review
- COUNT belongs to the Statistical category in Excel. Counts the number of cells that contain numbers.
- Full syntax: =COUNT(value1, [value2], ...). Open /functions/count/ for parameters, FAQs, and related pages.
- Common mistakes: Only counts numbers, not text; Dates and times are counted (they're numbers)
- Pair this function with comparison guides when another Excel formula might fit the same task better.
- Review fix-excel-formula-errors when unexpected errors appear after upgrading Excel or sharing across locales.