# SUMPRODUCT

Formulas / SUMPRODUCT
Return the sum of products from multiplying arrays.
`=SUMPRODUCT(array1,[array2],[array3],...)`
• array1 - required, the first array or range to multiply
• array2 - [OPTIONAL] the second or third array or range to multiply

## Examples

• `=SUMPRODUCT({150;108;210;144;198;180;120;144;198;160})`

The SUMPRODUCT function can be used to calculate the sum of a range of numbers. For example, this returns 1612. This example demonstrates the ability of the SUMPRODUCT function to sum a range of values quickly and easily.

• `=SUMPRODUCT(--(A2:A6="TX"))`

The SUMPRODUCT function can also be used to count the number of certain values found in a range. For example, this returns 1612. This example demonstrates the ability of the SUMPRODUCT function to quickly and easily count a certain value in a range of values.

## Summary

SUMPRODUCT is a versatile Sourcetable function that allows users to multiply arrays of cells and calculate sums, totals, and conditional sums and totals more efficiently than using COUNTIFS or SUMIFS.

• SUMPRODUCT is a versatile function that can be used to count and sum like COUNTIFS or SUMIFS, extend the functionality of other functions, handle arrays gracefully, and process ranges of cells in clever, elegant ways.
• SUMPRODUCT can also be used to calculate conditional sums of values.