Use `COUNTIF(range, criteria)` to count cells that meet one condition
Select the cell where you want the result
Type `=COUNTIF(`
Enter the range of cells to check
Add a comma
Enter the criteria in quotes if needed
Close the formula with `)`
Press Enter
Example: `=COUNTIF(A1:A10,”Apple”)`
Example: `=COUNTIF(B1:B20,”>=50″)`
Example: `=COUNTIF(C1:C15,”<>“)` to count non-empty cells
Use cell references for criteria if needed, such as `=COUNTIF(A1:A10,D1)`
Use wildcards like `*` for multiple characters and `?` for a single character
Use `COUNTIF` for text, numbers, dates, and logical conditions
Copy the formula to apply it to other ranges if needed