Home › Functions › Math & Trig › SUMIFS
fx
SUMIFS
Math & Trig  ·  Since: Excel 2007  ·  9 languages

The SUMIFS function, one of the math and trig functions , adds all of its arguments that meet multiple criteria. For example, you would use SUMIFS to sum the number of retailers in the country who (1) reside in a single zip code and (2) whose profits exceed a specific dollar value.

🌐 Translations

English SUMIFS
Deutsch SUMMEWENNS
Français SOMME.SI.ENS
Español SUMAR.SI.CONJUNTO
Italiano SOMMA.PIÙ.SE
Português SOMASES
Nederlands SOMMEN.ALS
Polski SUMA.WARUNKÓW
Русский СУММЕСЛИМН

📦 Availability

Excel versionAvailable
Excel 2007 ✓
Excel 2013 ✓
Excel 2019 ✓
Excel 2021 ✓
Microsoft 365 ✓
Translate a formula with this function
fx EN
fx DE

⌨ Syntax

SUMIFS(sum_range,criteria_range1,criteria1,[criteria_range2,criteria2],...)

Arguments

sum_range (required) — The range of cells to sum.
criteria_range1 (required) — The range that is tested using Criteria1 . Criteria_range1 and Criteria1 set up a search pair whereby a range is searched for specific criteria. Once items in the range are found, their corresponding values in Sum_range are added.
criteria1 (required) — The criteria that defines which cells in Criteria_range1 will be added. For example, criteria can be entered as 32 , ">32" , B4 , "apples" , or "32" .
criteria_range2, criteria2, ... (optional) — Additional ranges and their associated criteria. You can enter up to 127 range/criteria pairs.

▶ Examples

=SUMIFS(A2:A9,B2:B9,"=A*",C2:C9,"Tom")
=SUMIFS(A2:A9,B2:B9,"=A*",C2:C9,"To?")
=SUMIFS(A2:A9,B2:B9,"<>Bananas",C2:C9,"Tom")

Related functions

Copied to clipboard