This function returns the number of cells that meet multiple conditions.
COUNTIFS(cellrange,condition)
This function has these arguments:
| Argument | Description |
|---|---|
| cellrange | Range of cells to count; cell range reference |
| condition | Condition that determines which cells are counted, as a text, number, or expression |
Accepts cell range reference. Returns numeric data.
COUNTIFS(A1:G5,"test",B3:D3,"=Yes")
COUNTIFS(R6C3:R9C4,"<2")
