> For the complete documentation index, see [llms.txt](https://docs.tomat.ai/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.tomat.ai/data-transformation/formulas/aggregate-functions/countif.md).

# CountIf

Counts values in the column filtered by the condition

```mathematica
CountIf(column1, column2 > 11480) → 843
CountIf(column2, column2 > 5000) → 125
```

#### Inputs

`CountIf(column, [condition])`

* `column` - A column to count values
* `[condition]` - **\[optional]** - Condition to filter values in the column