COUNTIFS Function

Counts the number of cells within a range that meet all of the specified criteria.
Sample Usage
COUNTIFS(Quantity:Quantity, >25, [Item Name]:[Item Name], "T-Shirt")
Syntax
COUNTIFS(
  • range1
  • criterion1
  • [
    • range2
    • criterion2
    • ...
    ]
)
  • range1
    The group of cells to count.
  • criterion1
    The value that determines which cells in the range will be counted; for example: 15, "Hello World!", or >25.
    • range2
    • criterion2
    • ...
    —[optional]
    Additional groups of cells and their criteria.
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 =COUNTIFS(Item:Item, <> "Shirt",Warehouse:Warehouse, <> "Chicago") won't count any blank cells that exist in the Item and Warehouse columns.
Was this article helpful?
YesNo