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

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

Maximum Sales where Region is North