# COUNTIF

The COUNTIF function returns the count of items that match the specified condition.

### Syntax <a href="#syntax" id="syntax"></a>

### Arguments <a href="#arguments" id="arguments"></a>

list - List of values. This is a required argument.

condition - The condition to be evaluated. This is a required argument.

### Example <a href="#example" id="example"></a>

```excel-formula
COUNTIF([100,500,120],"<200")
```

Returns 2, since only two values in the given list, match the condition

### Excel equivalent <a href="#excel-equivalent" id="excel-equivalent"></a>

[COUNTIF](https://support.microsoft.com/en-us/office/countif-function-e0de10c6-f885-4e71-abb4-1f464816df34)