Returns the sum of the product of values in a series of columns.
number (required): A column to be multiplied and summed. You can enter in any number of columns to be multiplied together.
SumProduct([Quantity], [Unit Price])
- Finds the sum of the product of the columns [Quantity]*[Unit Price]
More About Aggregate Functions
If the column being aggregated is grouped, then the aggregate is computed for each group. For example, if the worksheet is grouped by the column [Year], then placing Sum([Revenue]) on the [Year] level computes the revenue for each year.
The results of aggregate functions can be referenced by lower levels. An example would be to create a Sum([Amount]) column as Total and then an [Amount] / [Total] column as Percentage. This converts each Amount value into a relative percentage value.