How can I use the SUMPRODUCT function in Google Sheets?

How can I use the SUMPRODUCT function in Google Sheets?

By /

The SUMPRODUCT function in Google Sheets is a useful tool that allows users to multiply corresponding values in two or more arrays and then sum the products together. This function can be used to perform various calculations such as weighted averages, total revenue, and more. To use the SUMPRODUCT function, simply enter the array or range of cells containing the values you want to multiply, separated by commas, within the parentheses. This function is particularly helpful for analyzing large sets of data and can save time and effort in manual calculations.

SUMPRODUCT

The SUMPRODUCT function calculates the sum of the products of corresponding entries in 2 equally sized arrays or ranges.

Sample Usage

SUMPRODUCT(A2:C5,D2:F5)

SUMPRODUCT({1,2,3,4},{5,6,7,8})

Syntax

SUMPRODUCT(array1, [array2, ...])

  • array1 – The first array or range whose entries will be multiplied with corresponding entries in the second such array or range.

  • array2, ... – [ OPTIONAL – {1,1,1,...} with same length as array1 by default ] – The second array or range whose entries will be multiplied with corresponding entries in the first such array or range.

Notes

  • Matrix multiplication, MMULT, can also be accomplished using a combination of TRANSPOSE and SUMPRODUCT functions.

See Also

TRANSPOSE: Transposes the rows and columns of an array or range of cells.

MMULT: Calculates the matrix product of two matrices specified as arrays or ranges.

Examples

[wpcc-iframe height=”300″ src=”https://docs.google.com/spreadsheet/pub?key=0As3tAuweYU9QdHhnN1RWWEUzeGlkc0RVN2ZfYllzdXc&output=html” width=”500″]

Cite this article

stats writer (2024). How can I use the SUMPRODUCT function in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-use-the-sumproduct-function-in-google-sheets/

stats writer. "How can I use the SUMPRODUCT function in Google Sheets?." PSYCHOLOGICAL SCALES, 1 Jul. 2024, https://scales.arabpsychology.com/stats/how-can-i-use-the-sumproduct-function-in-google-sheets/.

stats writer. "How can I use the SUMPRODUCT function in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-use-the-sumproduct-function-in-google-sheets/.

stats writer (2024) 'How can I use the SUMPRODUCT function in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-use-the-sumproduct-function-in-google-sheets/.

[1] stats writer, "How can I use the SUMPRODUCT function in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, July, 2024.

stats writer. How can I use the SUMPRODUCT function in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.

Download Post (.PDF)

Related terms:

  1. How can I use a SUMPRODUCT IF formula in Google Sheets?
  2. How to Easily Calculate Conditional Sums in Google Sheets Using SUMPRODUCT and IF
  3. How do I use SUMPRODUCT across multiple sheets in Excel?
  4. How can I use the SUMPRODUCT function in Excel to calculate the sum of values based on both row and column criteria?
  5. How can I use the SUMPRODUCT function in Excel to calculate the sum of multiple columns?
  6. How can I use the SUMPRODUCT function in VBA with an example?
  7. How can I use the SUMPRODUCT function in Excel to calculate the sum of products for a range of cells?
  8. How to Easily SUM Values Across Multiple Sheets in Excel Using SUMPRODUCT
  9. How can I use SUBTOTAL with SUMPRODUCT in Excel?
  10. How can I use SUMPRODUCT in Excel to only calculate values that are greater than zero?
Slide Up
x
PDF
Scroll to Top