COUNT

Beginner

Statistical

Counts the number of cells that contain numbers in a range. Ignores text, logical values, and empty cells.

Syntax
=COUNT(value1, [value2], ...)
Parameters
value1
Required
(any)

First value or range to count

value2(any)

Additional values or ranges (optional)

Examples
Real-world examples to help you understand how to use COUNT

Count numeric cells

=COUNT(A1:A10)

Counts how many cells contain numbers

Result: Number of numeric cells

Count across multiple ranges

=COUNT(A1:A10, C1:C10)

Counts numbers in both ranges

Result: Combined count

Count with criteria

=COUNTIF(A1:A10, ">100")

Counts cells with values greater than 100

Result: Count of cells > 100

Common Use Cases
  • ✓Count responses in surveys
  • ✓Track number of sales transactions
  • ✓Count valid data entries
  • ✓Quality control checks
  • ✓Inventory counting
Pro Tips
  • 💡COUNT only counts numbers, not text
  • 💡Use COUNTA to count non-empty cells including text
  • 💡Use COUNTBLANK to count empty cells
  • 💡Combine with SUMIF for conditional sums
Common Errors
  • ⚠️Counting text values (use COUNTA instead)
  • ⚠️Not accounting for hidden or filtered cells
  • ⚠️Confusion between COUNT and COUNTA
Related Formulas
COUNTACOUNTIFCOUNTIFSCOUNTBLANK

Need a Custom COUNT Formula?

Our AI can generate tailored formulas based on your specific needs

Generate Custom Formula