Skip to main content

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.

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