Spread Formula Reference
Formula Functions / Functions R to S / SUMPRODUCT
In This Topic
    SUMPRODUCT
    In This Topic

    This function returns the sum of products of cells. Multiplies corresponding components in the given arrays, and returns the sum of those products.

    Syntax

    SUMPRODUCT(array1,array2,...)

    Arguments

    There must be at least two arrays (array1, array2) and optionally up to 255 arrays (array3, ...) as arguments. The arrays must have the same dimension.

    Data Types

    Accepts numeric data for all arguments. Returns numeric data.

    Examples

    SUMPRODUCT(A1:A17,B1:B17,C1:C17)

    SUMPRODUCT({2,3,5,6,4,7},{5,6,4,4,7,2}) gives the result 114

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    PRODUCT | SUM | Math and Trigonometry Functions