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.
Need help with Formulas?
Frequently Asked Questions
What is the SUMPRODUCT function?
What is the SUMPRODUCT function used for?
How does the SUMPRODUCT function handle arrays?
What kind of data can the SUMPRODUCT function compare?
Work smarter
Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.