COUNTIF

Intermediate

Statistical

Counts cells that meet a specific condition. Essential for conditional counting and data analysis.

Syntax
=COUNTIF(range, criteria)
Parameters
range
Required
(range)

Range of cells to count

criteria
Required
(text | number | expression)

Condition that determines which cells to count

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

Count cells greater than value

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

Counts cells with values greater than 50

Result: Number of cells > 50

Count specific text

=COUNTIF(B1:B10, "Yes")

Counts how many cells contain "Yes"

Result: Count of Yes responses

Count with wildcard

=COUNTIF(A1:A10, "A*")

Counts cells starting with letter A

Result: Count of A* entries

Common Use Cases
  • ✓Count survey responses
  • ✓Track completion status
  • ✓Count values above threshold
  • ✓Analyze data distribution
  • ✓Quality control checks
Pro Tips
  • 💡Use * for any characters, ? for single character
  • 💡Criteria is not case-sensitive
  • 💡Can count both numbers and text
  • 💡Combine with other functions for complex logic
Common Errors
  • ⚠️Forgetting quotes around criteria
  • ⚠️Not escaping special characters in criteria
  • ⚠️Confusion between COUNT and COUNTIF
Related Formulas
COUNTCOUNTACOUNTIFSSUMIF

Need a Custom COUNTIF Formula?

Our AI can generate tailored formulas based on your specific needs

Generate Custom Formula