SumIf

Sums values in a column only for rows matching the condition Category: aggregate Syntax:

SumIf([column], condition 1, [condition 2], ...)

Returns: Number Context Filtering: ✗ No

Parameters

Name	Type	Required	Description
`column`	`column`	✓ Yes	The numeric column to sum when condition is True
`condition 1`	`logical`	✓ Yes	Logical expression evaluated per row
`additional conditions`	`variadic`	✗ No	Additional conditions combined with AND by default

Allowed Column Types for column: INT, FLOAT, DECIMAL

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

Sums Sales where Region is North

Last modified on March 13, 2026