> 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/countif.md).

# 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.