# COUNTIFS

## Content

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

## Syntax

`COUNTIFS(cellrange, condition)`

## Arguments

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 |

## Data Types

Accepts cell range reference. Returns numeric data.

## Examples

`COUNTIFS(A1:G5,"test",B3:D3,"=Yes")`

`COUNTIFS(R6C3:R9C4,"<2")`