# How to use Excel SUMIFS function

## SUMMARY INFO

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

 Function: SUMIFS Function Category: Math and trigonometry Description: Adds the cells in a range that meet multiple criteria Return Value: The sum of the cells that meet all criteria Syntax: =SUMIFS (sum_range, range1, criteria1, [range2], [criteria2], …) Applies to: Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007 Other languages: English: SUMIFS French: SOMME.SI.ENS German: SUMMEWENNS Spanish: SUMAR.SI.CONJUNTO Dutch: SOMMEN.ALS Italian: SOMMA.PIÙ.SE Russian: СУММЕСЛИМН Danish: SUM.HVISER Swedish: SUMMA.OMF Portuguese (Brazil): SOMASES Polish: SUMA.WARUNKÓW Finnish: SUMMA.JOS.JOUKKO Norwegian: SUMMER.HVIS.SETT Portuguese (Portugal): SOMA.SE.S Czech: SUMIFS Hungarian: SZUMHATÖBB Turkish: ÇOKETOPLA All Other Languages: SUMIFS Related Functions: SUM, SUMIF

## FUNCTION DETAILS

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

### =SUMIFS (sum_range, range1, criteria1, [range2], [criteria2], …)

sum_range The range to be summed.
range1 The first range to evaulate.
criteria1 The criteria to use on range1.
range2 [optional] The second range to evaluate.
criteria2 [optional] The criteria to use on range2.

## VIDEO EXAMPLES

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

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

Microsoft Office support page – Excel SUMIFS function:
https://support.office.com/en-us/article/SUMIFS-function-c9e748f5-7ea7-455d-9406-611cebce642b

## 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: