# How to use Excel SUMPRODUCT function

## SUMMARY INFO

All the basic information regarding Excel SUMPRODUCT function is listed in the table below. (This data is regularly updated from Microsoft and several resources)

 Function: SUMPRODUCT Function Category: Math and trigonometry Description: Returns the sum of the products of corresponding array components Return Value: The result of multipled and summed arrays. Syntax: =SUMPRODUCT (array1, [array2], …) Applies to: Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000 Other languages: English: SUMPRODUCT French: SOMMEPROD German: SUMMENPRODUKT Spanish: SUMAPRODUCTO Dutch: SOMPRODUCT Italian: MATR.SOMMA.PRODOTTO Russian: СУММПРОИЗВ Danish: SUMPRODUKT Swedish: PRODUKTSUMMA Portuguese (Brazil): SOMARPRODUTO Polish: SUMA.ILOCZYNÓW Finnish: TULOJEN.SUMMA Norwegian: SUMMERPRODUKT Portuguese (Portugal): SOMARPRODUTO Czech: SOUČIN.SKALÁRN Hungarian: SZORZATÖSSZEG Turkish: TOPLA.ÇARPIM All Other Languages: SUMPRODUCT Related Functions: SUM, SUMIF, SUMIFS

## FUNCTION DETAILS

Syntax details with an example regarding the correct usage of function can be seen below.

### =SUMPRODUCT (array1, [array2], …)

array1 The first array or range to multiply, then add.
array2 [optional] The second array or range to multiply, then add.

## VIDEO EXAMPLES

Check the video below to see How to use Excel SUMPRODUCT function with some examples:

Here we provide a list of useful links which we think can be useful while trying to learn how to use SUMPRODUCT function usage with some examples and tips.

Microsoft Office support page – Excel SUMPRODUCT function:
https://support.office.com/en-us/article/SUMPRODUCT-function-16753e75-9f68-4874-94ac-4d2145a2fd2e

Some unlikely uses for Excel’s SUMPRODUCT function:
https://www.accountingweb.com/technology/excel/some-unlikely-uses-for-excels-sumproduct-function

## EXCEL FORMULAS TRAINER

As said: Practice Makes Perfect!

Test your Excel skills in Excel itself with our unique product: Excel Formulas Trainer.

30 sections and around 100 questions with full hands-on experience. Progress tracking, dashboard, error checking and many more. Check it now: