Netmend

Netmend · Excel functions · SUMIFS = SOMA.SE.S

SUMIFS in Portuguese = SOMA.SE.S

SUMIFS = SOMA.SE.S = SUMAR.SI.CONJUNTO = SOMME.SI.ENS = SUMMEWENNS = SOMMA.PIÙ.SE. Adds numbers that meet several conditions at once.

6 languagesSyntax + exampleFixes , vs ;Free translator

What SUMIFS does

The standard way to total by category and date, or by account and row number (for a running balance). The argument order is not the same as SUMIF.

Adds numbers that meet several conditions at once.

Syntax and a worked example in 6 languages

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.

English — SUMIFS
=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)
=SUMIFS(C:C,B:B,"Rent",A:A,">="&DATE(2026,1,1))
Português (PT) — SOMA.SE.S
=SOMA.SE.S(sum_range; criteria_range1; criteria1; [criteria_range2; criteria2]; …)
=SOMA.SE.S(C:C;B:B;"Rent";A:A;">="&DATA(2026;1;1))
Español — SUMAR.SI.CONJUNTO
=SUMAR.SI.CONJUNTO(sum_range; criteria_range1; criteria1; [criteria_range2; criteria2]; …)
=SUMAR.SI.CONJUNTO(C:C;B:B;"Rent";A:A;">="&FECHA(2026;1;1))
Français — SOMME.SI.ENS
=SOMME.SI.ENS(sum_range; criteria_range1; criteria1; [criteria_range2; criteria2]; …)
=SOMME.SI.ENS(C:C;B:B;"Rent";A:A;">="&DATE(2026;1;1))
Deutsch — SUMMEWENNS
=SUMMEWENNS(sum_range; criteria_range1; criteria1; [criteria_range2; criteria2]; …)
=SUMMEWENNS(C:C;B:B;"Rent";A:A;">="&DATUM(2026;1;1))
Italiano — SOMMA.PIÙ.SE
=SOMMA.PIÙ.SE(sum_range; criteria_range1; criteria1; [criteria_range2; criteria2]; …)
=SOMMA.PIÙ.SE(C:C;B:B;"Rent";A:A;">="&DATA(2026;1;1))

Common mistakes

Translate a formula with SUMIFS

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.

Stuck with a spreadsheet? We fix it. From $25

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.

Send the sheet

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.

FAQ

What is SUMIFS in Portuguese?

SOMA.SE.S. Spanish SUMAR.SI.CONJUNTO, French SOMME.SI.ENS, German SUMMEWENNS, Italian SOMMA.PIÙ.SE.

Why is the argument order different from SUMIF?

Historical accident. Remember: SUMIFS starts with the numbers you are adding.

How do I do a running balance by account?

Add a row-number helper column, then SUMIFS of Money in minus SUMIFS of Money out, both filtered to that account and to rows up to the current one. Transfers between accounts should be two rows (out of A, into B), not one.

Related functions

Bank statement → CSV · Testimonial wall · Pinterest pin maker · All Netmend services