# COUNTIF

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

## Syntax

```javascript
countif(list, condition)
```

## Arguments

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

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

## Example

```javascript
COUNTIF([100,500,120],"<200")
```

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

## Excel equivalent

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