Use COUNTIF to count cells that meet one condition
Syntax: `=COUNTIF(range, criteria)`
Replace `range` with the cells you want to check
Replace `criteria` with the condition to count
Count exact text: `=COUNTIF(A1:A10,”Apple”)`
Count numbers greater than a value: `=COUNTIF(A1:A10,”>10″)`
Count numbers less than a value: `=COUNTIF(A1:A10,”<5")`
Count cells equal to a cell reference: `=COUNTIF(A1:A10,B1)`
Count nonblank cells with a condition: `=COUNTIF(A1:A10,”<>“)`
Use wildcards for text matching
Use `*` for any number of characters
Use `?` for a single character
Count text containing a word: `=COUNTIF(A1:A10,”*apple*”)`
Use quotes around text criteria and comparison operators
Use cell references directly for criteria when needed
Combine with other functions if needed for more complex counting