COUNT function

COUNT counts the number of cells containing numeric values and dates in one or more ranges, ignoring text and blank cells.

=COUNT(value1, ...)

Generate a COUNT formula

Describe what you need. The generator will reach for COUNT where COUNT is the right tool, and tell you when it is not.

How to get a better answer
  • Name your columns by letter and by header: "column F (Net Value)" beats "the amount column".
  • State every condition, including the negatives — "not cancelled" changes the formula's shape.
  • Say where the data starts if it is not row 1, and whether it will grow.
  • Check the settings above match your spreadsheet: the wrong argument separator is a syntax error on your machine.

Arguments

How COUNT reads its arguments
value1requiredCOUNT →
ArgumentRequiredDescription
value1RequiredA cell, range, or array to count. Can be a number, date, formula result, or range containing mixed data types.
...RepeatingAdditional cells, ranges, or values to count. All arguments are processed; only numeric values are counted.

Returns

A single integer representing the count of numeric values found across all arguments.

Availability

Excel: All · Google Sheets: Supported

Worked examples

1. Count how many support tickets received satisfaction ratings

Ticket IDPriorityOpenedClosedAgentCSAT
T001High2024-01-152024-01-16Alice5
T002Medium2024-01-152024-01-17Bob4
T003High2024-01-16Bob
T004Low2024-01-162024-01-20Carol3
T005Medium2024-01-172024-01-18Alice5
T006High2024-01-17Alice
T007Low2024-01-182024-01-19Carol2
=COUNT(F2:F8)

Result: 5

The CSAT column (F2:F8) contains seven cells: five with numeric ratings (5, 4, 3, 5, 2) and two blanks. COUNT ignores the blank cells and returns 5, representing the number of tickets with actual satisfaction scores recorded.

2. Count all resolved support tickets by closure date

Ticket IDPriorityOpenedClosedAgentCSAT
T001High2024-01-152024-01-16Alice5
T002Medium2024-01-152024-01-17Bob4
T003High2024-01-16Bob
T004Low2024-01-162024-01-20Carol3
T005Medium2024-01-172024-01-18Alice5
T006High2024-01-17Alice
T007Low2024-01-182024-01-19Carol2
=COUNT(D2:D8)

Result: 5

The Closed column (D2:D8) holds closure dates for resolved tickets and blanks for open tickets. COUNT treats dates as numeric values internally, so it counts the five cells with closure dates and ignores the two empty cells for unresolved tickets.

3. Count all tickets opened, including still-open ones

Ticket IDPriorityOpenedClosedAgentCSAT
T001High2024-01-152024-01-16Alice5
T002Medium2024-01-152024-01-17Bob4
T003High2024-01-16Bob
T004Low2024-01-162024-01-20Carol3
T005Medium2024-01-172024-01-18Alice5
T006High2024-01-17Alice
T007Low2024-01-182024-01-19Carol2
=COUNT(C2:C8)

Result: 7

The Opened column (C2:C8) contains seven dates—every ticket has an open date. COUNT returns 7, contrasting with the Closed column, which has blanks for open tickets and returns only 5.

Common errors

Which COUNT error are you seeing?
COUNT returned an error#REF!
Update the formula to reference a valid, existing column, or undo the deletion.
#N/A
Resolve the source error in the range (fix the lookup), or wrap it with IFERROR to suppress errors before they reach COUNT.
#NAME?
Correct the function name to COUNT and verify the syntax is valid.
ErrorWhy it happensHow to fix it
#REF!A column referenced in the formula is deleted or moved (e.g., if the Closed column is deleted, =COUNT(D2:D8) breaks because D no longer refers to that data).Update the formula to reference a valid, existing column, or undo the deletion.
#N/AA cell within the counted range contains an #N/A error, often from a failed VLOOKUP or MATCH formula elsewhere in the dataset.Resolve the source error in the range (fix the lookup), or wrap it with IFERROR to suppress errors before they reach COUNT.
#NAME?The function name is misspelled (e.g., =COUNT5 or =COUNTS instead of =COUNT).Correct the function name to COUNT and verify the syntax is valid.

Tips and when to use something else

  • COUNT counts only numeric values and dates; use COUNTA if you need to count all non-blank cells, including text entries like agent names.
  • Dates are stored as numbers internally, so COUNT recognizes and counts them without any conversion.
  • For conditional counting (e.g., 'count tickets with CSAT > 4'), use COUNTIF or COUNTIFS instead of COUNT.
  • If COUNT returns 0 when you expect a higher count, check whether your data is stored as text rather than numbers—import or format conversion may be needed.

Related functions

COUNTACOUNTA counts the number of non-empty cells in a range, regardless of their content type or whether they contain text, numbers, or errors.COUNTIFCounts cells in a range that meet a specific criterion, returning a number — use it to tally matching rows like employee counts by department.COUNTIFSCOUNTIFS counts rows where all criteria are met across multiple ranges, useful for filtering inventory and finding matches across conditions.AVERAGEAVERAGE calculates the arithmetic mean of numbers, ignoring text and logical values; returns a single numeric value representing the average.MAXIFSReturns the largest value in a range that meets multiple criteria, combining the power of MAX with IF-like filtering.

Frequently asked questions

Does COUNT include zero values?
Yes. COUNT counts any numeric value, including zero. Only blank cells and non-numeric data (text, logical values) are ignored.
Why does COUNT return 0 when I count a column of numbers stored as text?
COUNT counts only true numeric values. Numbers stored as text (often from imports or formatting) are invisible to COUNT. Use COUNTA to count text, or convert the text to actual numbers first using VALUE or Data > Text to Columns.
What is the difference between COUNT and COUNTA?
COUNT counts only numeric values (and dates). COUNTA counts any non-blank cell, including text. In the ticket data, COUNT(F:F) counts only CSAT ratings, while COUNTA(F:F) would also count the header 'CSAT'.
Can I count only tickets with specific satisfaction scores, like CSAT = 5?
No, COUNT counts all numeric values equally. For conditional counting, use COUNTIF(F2:F8, 5) to count only tickets with CSAT equal to 5, or COUNTIF(F2:F8, ">4") for scores above 4.

Need a different formula?

The full generator is not scoped to one function — describe any spreadsheet problem and it will pick.

Open the formula generator

Reviewed 2026-09-17