Function Index

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.

Examples

SumProduct([Quantity], [Unit Price])
  • Finds the sum of the product of the columns [Quantity]*[Unit Price]