Counts the number of cells within a range that meet a 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.
- 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.