# COUNTIFS

COUNTIFS( `column`, `criteria`,\[ `additional_column`, `additional_criteria`,...])

Counts the values in a `column` that are within a row meeting all specified `criteria`; multiple `column`, `criteria` pairs can be input.

### Arguments

| Argument              | Description                                                                                                                           |
| --------------------- | ------------------------------------------------------------------------------------------------------------------------------------- |
| `column`              | Column to count                                                                                                                       |
| `criteria`            | Condition that must be met for `column` to be counted. May reference the same or different column than `column`                       |
| `additional_column`   | Additional `column` to count                                                                                                          |
| `additional_criteria` | Condition that must be met for `additional_column` to be counted. May reference the same or different column than `additional_column` |

### Outputs

Outputs count of values in `column`(s) that meet all `criteria`

### Example

With this formula:

`COUNTIFS({Adult Population}, {Child Population} < 1000000, {Adult Population}, {Region}="East")`

We see the resulting table. Criteria are applied to `{Region}`and `{Child Population}`, while `{Adult Population}` is being counted.

{% embed url="<https://datawrapper.dwcdn.net/Fq8ru/1/>" %}