Skip to main content
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

NameTypeRequiredDescription
columncolumn✓ YesThe numeric column to sum when condition is True
condition 1logical✓ YesLogical expression evaluated per row
additional conditionsvariadic✗ NoAdditional conditions combined with AND by default
Allowed Column Types for column: INT, FLOAT, DECIMAL

​
Validation

  • Minimum parameters: 2
  • Maximum parameters: None

​
Examples

SumIf([Sales], [Region] = "North")
Sums Sales where Region is North
Last modified on March 13, 2026