Counts the number of cells within a range that meet a criterion.
Sample Usage
COUNTIF(Quantity:Quantity, >25)
Syntax
COUNTIF(
- range
- criterion
- range—The group of cells to count.
- criterion—The value that determines which cells in the range will be counted; for example: 15, "Hello World!", or >25.
Usage Notes
- For criterion, acceptable operators include: = (equal to), <> (not equal to), > (greater than), < (less than), >= (greater than or equal to), <= (less than or equal to).
- Blank cells aren't counted when using <> (not equal to). For example, the formula =COUNTIF(Item:Item, <> "Shirt") won't count any blank cells that exist in the Item column.