> For the complete documentation index, see [llms.txt](https://docs.cascade.io/cascade/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.cascade.io/cascade/functions-and-expressions/functions/aggregate/countifs.md).

# 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/>" %}