> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://help.sigmacomputing.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://help.sigmacomputing.com/_mcp/server.

# MaxIf

> Use the Sigma MaxIf function to find the maximum value for a column or group if the conditions are true.

The **MaxIf** function finds the maximum value for a column or group if the conditions are true.

The **MaxIf** function is an aggregate function.

Aggregate functions evaluate one or more rows of data and return a single value.

In a table element, the aggregate is calculated for each grouping. For information on how to add a grouping with an aggregate calculation to a table, see [Group columns in a table](/docs/create-and-manage-tables#group-columns-in-a-table).

In a table with no groupings, the aggregate is calculated for each row. For information on how to calculate summary statistics across all rows in a table, see [Add summary statistics to a table](/docs/create-and-manage-tables#add-summary-statistics-to-a-table).

To learn more about using aggregate functions, see [Building complex formulas with grouped data](https://www.sigmacomputing.com/resources/training-videos/table-grouping-and-functions#complex-formulas).

## Syntax

`MaxIf(field, condition)`

Function arguments:

* **field** (required) - The column to search.
* **condition** (required) - The condition to test. For each row, if the condition is True, it is included in the aggregate calculation.

## Notes

* The **field** argument must be a value with the **Number**, **Date**, or **Text** [data type](/docs/data-types-and-formats).

## Examples

```
MaxIf([Distance], [Departure Delay] > 0)
```

* In a table summary, returns the greatest *Distance* from among all rows in the table where *Departure Delay* is greater than 0.
* In a calculated column in an ungrouped table, returns each row's own *Distance* value. If *Departure Delay* is not greater than 0, returns `Null`.
* In a table grouped by *Airline*, returns the greatest *Distance* for each airline from among all rows in the grouping where *Departure Delay* is greater than 0.

```
MaxIf([Invoice Date], [State] = "TX")
```

* Finds the greatest Invoice Date for all entries where the State indicated is Texas.

```
MaxIf([Sales], [Region] = "East" AND [Status] = "Complete")
```

* Finds the maximum Sale value for entries in the "East" Region that are marked as "Complete".

## Related resources

* [Max](/docs/max)
* [AvgIf](/docs/avgif)
* [MinIf](/docs/minif)