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])

Related resources