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


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.


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 Functions

Was this page helpful?
Yes No