SumProduct
Returns the sum of the product of values in a series of columns.
Usage
SumProduct(number, ...)
number (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]