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

# MaxIf

Returns the maximum value in a column only for rows matching the condition

**Category:** `aggregate`

**Syntax:**

```
MaxIf([column], condition)
```

**Returns:** `Number`

**Context Filtering:** ✗ No

## Parameters

| Name        | Type      | Required | Description                                                  |
| ----------- | --------- | -------- | ------------------------------------------------------------ |
| `column`    | `column`  | ✓ Yes    | The column to find maximum value from when condition is True |
| `condition` | `logical` | ✓ Yes    | Logical expression evaluated per row                         |

**Allowed Column Types for `column`:** INT, FLOAT, DECIMAL, DATE, DATETIME

## Validation

* Minimum parameters: 2
* Maximum parameters: 2

## Examples

```
MaxIf([Sales], [Region] = "North")
```

Maximum Sales where Region is North