> ## Documentation Index
> Fetch the complete documentation index at: https://docs.anlytic.com/llms.txt
> Use this file to discover all available pages before exploring further.

# CountIf

Counts rows matching the specified condition(s)

**Category:** `aggregate`

**Syntax:**

```
CountIf(condition 1, [condition 2], ...)
```

**Returns:** `Number`

**Context Filtering:** ✗ No

## Parameters

| Name                    | Type       | Required | Description                                        |
| ----------------------- | ---------- | -------- | -------------------------------------------------- |
| `condition 1`           | `logical`  | ✓ Yes    | Logical expression evaluated per row               |
| `additional conditions` | `variadic` | ✗ No     | Additional conditions combined with AND by default |

## Validation

* Minimum parameters: 1
* Maximum parameters: None

## Examples

```
CountIf([Sales] > 1000)
```

Counts rows where Sales is greater than 1000