COUNTIF Function

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.
Was this article helpful?
YesNo