SUMPRODUCT
Formulas / SUMPRODUCTReturn 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.
Frequently Asked Questions
What is the SUMPRODUCT function?
The SUMPRODUCT function is a math and trigonometry function that multiplies the components of an array and returns the sum of the products of two or more numbers.
What is the SUMPRODUCT function used for?
The SUMPRODUCT function can be used for a variety of things, including calculating a weighted average, comparing data in more than two ranges, and calculating data with multiple criteria.
How does the SUMPRODUCT function handle arrays?
The SUMPRODUCT function can handle arrays in different ways depending on the type of array.
What kind of data can the SUMPRODUCT function compare?
The SUMPRODUCT function can compare data in more than two ranges and can calculate data with multiple criteria.
