Counts the number of cells within a range that meet all of the specified criteria.
COUNTIFS(Quantity:Quantity, >25, [Item Name]:[Item Name], "T-Shirt")
- 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.
Additional groups of cells and their criteria.
- 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.