# How to use Excel SUMIF function

## SUMMARY INFO

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

 Function: SUMIF Function Category: Math and trigonometry Description: Adds the cells specified by a given criteria Return Value: The sum of values supplied. Syntax: =SUMIF (range, criteria, [sum_range]) Applies to: Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000 Other languages: English: SUMIF French: SOMME.SI German: SUMMEWENN Spanish: SUMAR.SI Dutch: SOM.ALS Italian: SOMMA.SE Russian: СУММЕСЛИ Danish: SUM.HVIS Swedish:  SUMMA.OM Portuguese (Brazil): SOMASE Polish: SUMA.JEŻELI Finnish: SUMMA.JOS Norwegian: SUMMERHVIS Portuguese (Portugal): SOMA.SE Czech: SUMIF Hungarian: SZUMHA Turkish: ETOPLA All Other Languages: SUMIF Related Functions: SUM, SUMIFS

## FUNCTION DETAILS

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

### =SUMIF (range, criteria, [sum_range])

range The range of cells that you want to apply the criteria against.
criteria The criteria used to determine which cells to add.
sum_range [optional] The cells to add together. If sum_range is omitted, the cells in range are added together instead.

## VIDEO EXAMPLES

Check the video below to see How to use Excel SUMIF 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 SUMIF function:
https://support.office.com/en-us/article/SUMIF-function-169b8c99-c05c-4483-a712-1697a653039b

Excel SUMIF function examples: