# COUNTIF

COUNTIF( `column`, `criteria` )

Counts the values in a `column` that are within a row meeting the specified `criteria`

### Arguments

| Input      | Description                                                                                                                              |
| ---------- | ---------------------------------------------------------------------------------------------------------------------------------------- |
| `column`   | Column to count                                                                                                                          |
| `criteria` | Condition that must be met for values within `column` to be counted. `criteria` may reference the same or different column as `column` . |

### Output

Outputs count of values in `column` that meet `criteria`

### Example

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

In this example, there are two rows with `{Child Population}<1000000` , but because`COUNTIF` is aggregating `{Adult population}`, a null value decreases the count by 1.