SumProduct

The SumProduct function returns the sum of the product of values in a series of columns.

Syntax

SumProduct(column, ...)

Function arguments:

• column (required) - A column to be multiplied and summed. You can enter in any number of columns to be multiplied together.

Example

SumProduct([Quantity], [Unit Price])

• Finds the sum of the product of the columns [Quantity] * [Unit Price]

• This function is an alias for Sum([Quantity] * [Unit Price])