COUNTIF Function in Excel
Beginner
Counts the number of cells within a range that meet a single criterion.
Syntax
=COUNTIF(range, criteria)Example
Use Case
Count how many sales were greater than $100.
Common Errors to Avoid
- Forgetting quotes around text criteria (e.g., 'Paid' not Paid)
- Using wrong operators - need quotes: ">100" not >100
- Case-insensitive matching can cause unexpected results
Pro Tips
For multiple criteria, use COUNTIFS instead. Use wildcards (* and ?) for partial text matching. Reference cells for criteria to make formulas dynamic: COUNTIF(A:A, ">"&B1).
Need help with this formula?
Our AI Formula Generator can write this for you instantly.
Try AI Formula Generator →