COUNTIF
Math FormulasLearn COUNTIF to count cells meeting specific criteria. Count text, numbers, dates, blanks, and use wildcards.
Syntax
COUNTIF(range, criteria)Parameters
rangeThe range of cells to count
criteriaThe condition that determines which cells to count
Examples
=COUNTIF(A:A, "Apple")Count cells containing 'Apple'
=COUNTIF(B:B, ">50")Count cells greater than 50
=COUNTIF(A:A, "<>")Count non-empty cells
Common Errors
Returns 0 if no matches
Text criteria are case-insensitive
Pro Tips
Use "<>" to count non-blanks
Wildcards: * for any characters, ? for single character
For multiple criteria use COUNTIFS
Related Functions
Need Help with COUNTIF?
Describe your specific use case and our AI will generate the perfect COUNTIF formula for you.
Generate COUNTIF Formula