# COUNTIFS

## Content

This function returns the number of cells that meet multiple conditions.

## Syntax

`COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], ...)`

## Arguments

This function has these arguments:

| Argument | Description |
| -------- | ----------- |
| *criteria\_range1* | [Required] The first range in which to evaluate the associated criteria. |
| *criteria1* | [Required] The criteria in the form of a number, expression, cell reference, or text that define which cells will be counted. For example, criteria can be expressed as 32, ">32", B4, "apples", or "32". |
| *criteria\_range2, criteria2, ...* | [Optional] Additional ranges and their associated criteria. Up to 127 range/criteria pairs are allowed. |

## Examples

`COUNTIFS(A1:G5,"test",B3:D3,"=Yes")`
`COUNTIFS(R6C3:R9C4,"<2")`