Netmend · Excel functions · SUMPRODUCT = SOMARPRODUTO
SUMPRODUCT = SOMARPRODUTO = SUMAPRODUCTO = SOMMEPROD = SUMMENPRODUKT = MATR.SOMMA.PRODOTTO. Multiplies ranges together and adds the results. Also a way to do conditional sums in older Excel.
Before SUMIFS, this was how you did “total where category = Rent”. It is still the way to do weighted totals and some OR conditions. The Italian name MATR.SOMMA.PRODOTTO is a frequent search.
Multiplies ranges together and adds the results. Also a way to do conditional sums in older Excel.
English Excel uses commas between arguments and a dot decimal. Most European Excel versions use semicolons and a decimal comma. TRUE / FALSE also change name. The translator below applies all three.
=SUMPRODUCT(array1, [array2], …)
=SUMPRODUCT((B2:B100="Rent")*(C2:C100))
=SOMARPRODUTO(array1; [array2]; …)
=SOMARPRODUTO((B2:B100="Rent")*(C2:C100))
=SUMAPRODUCTO(array1; [array2]; …)
=SUMAPRODUCTO((B2:B100="Rent")*(C2:C100))
=SOMMEPROD(array1; [array2]; …)
=SOMMEPROD((B2:B100="Rent")*(C2:C100))
=SUMMENPRODUKT(array1; [array2]; …)
=SUMMENPRODUKT((B2:B100="Rent")*(C2:C100))
=MATR.SOMMA.PRODOTTO(array1; [array2]; …)
=MATR.SOMMA.PRODOTTO((B2:B100="Rent")*(C2:C100))
+) instead of multiplying them (*). That quietly gives the wrong total.Paste any formula. Function names and separators are converted between English, Portuguese, Spanish, French, German and Italian.
Sheet names and cell references are not translated. Google Sheets accepts English function names, but uses your locale’s separators.
Broken lookups, a running balance that will not stay still, a translated workbook full of #NAME? errors. Fixed price after we see the file. 48h.
Who handles the data: Pedro Carvalho (Netmend), dayinportugal@gmail.com. Files are used only for the order and deleted after delivery. No address, phone or national ID is asked for or published.
If you just need the function names and 20 practice exercises, the Excel cheat sheet is $5 on Gumroad. Payment is on Gumroad, not on this site.
SOMARPRODUTO. Spanish SUMAPRODUCTO, French SOMMEPROD, German SUMMENPRODUKT, Italian MATR.SOMMA.PRODOTTO.
Use SUMIFS when every condition is a simple “equals / greater than”. Use SUMPRODUCT for weighted totals, OR patterns, or older files.