SumProduct

Multiplies corresponding values from multiple columns and returns their sum Category: aggregate Syntax:

SumProduct([column1], [column2])

Returns: Number Context Filtering: ✗ No

Parameters

Name	Type	Required	Description
`column1`	`column`	✓ Yes	The first numeric column to multiply
`column2`	`column`	✓ Yes	The second numeric column to multiply

Allowed Column Types for column1: INT, FLOAT, DECIMAL Allowed Column Types for column2: INT, FLOAT, DECIMAL

SumProduct([Quantity], [Price])

Sum of (Quantity * Price) for all rows

Last modified on March 6, 2026