SUMIF Function in Excel

Home/Excel Formulas/SUMIF Function in Excel

What is the use of SUMIF function?

SUMIF Function in Excel adds all numbers in a range based on a given criteria



50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates

What is the syntax of SUMIF function?

SUMIF Function in Excel - Syntax

SUMIF( range, criteria,

[sum_range] )

range: range of cells that you want to check the criteria
criteria: condtion which you want to applay
[sum_range]: range of cells to sum based on criteria, if it is missing it will consider the first rang as sum_range

SUMIF Function in Excel – Examples

SUMIF Function in Excel- Example 1

Example 1: adding the salaries more than 2500
Example 2: adding all Salaries of HR Department
Example 3: adding all Salaries of Year 2012
Example 4: adding all Salaries of Year 2012
Example 5: adding all Salaries of Admin Department


Please refer the below article for more Math & Trig Excel functions.
Math & Trig Excel Formulas

Please refer the below article for more Excel Functions.
Excel Formulas | Home

By |January 30th, 2013|Excel Formulas|0 Comments

About the Author:

Excel VBA Developer having around 8 years of experience in using Excel and VBA for automating the daily tasks, reports generation and dashboards preparation. Valli is sharing to helps us automating daily tasks.

Leave A Comment

Related pages

business analyst faq interview questionsexcel macro delete sheetexcel colorindexshortcut to switch between excel workbookssumif function in excelcountif examplevlookup argumentscomparison operators excelvba copycollections in vbavba create fileexcel macro current rowcolumn addition worksheetaccess 2007 msgboxisblank vbahow to remove a checkbox in excelhow to protect worksheet in excelmacro to find duplicates in excelvba powerpoint tutorialvba for each worksheet in workbookexcel unlock password protected sheetdelete row based on cell value vbaexcel macro tipsfind duplicates in excel 2013excel lock sheethow to unhide cells in excel 2010form excel vbahow to do the vlookup in excel 2010blank excel worksheetexamples of vlookup in excel 2010excel unlock cellswhy we use hlookup in excelhow to unprotect excel sheet 2010 without passworddim fso as filesystemobjectmerge cells excellloop function in excelhow to create a sales dashboard in excelvisual basic excel tutorial pdfrange command vbadefinition of charts in excelprotect formulas in excel 2007excel how to make a pivot tablevb basic codeswhere to find developer tab in excel 2010conditional formatting in excel 2007 using if statementmerging cells in excel 2007how to unhide rows and columns in excel 2010excel functions and formulas with examplesarray excel macroexcel macro delete columnvlookup function with examplevba example programsisna excelvba excel for loopexcel vba istextvba hyperlink excelbasic vba codewebsite project plan template excelcode in vbavba secondsexcel vba tabmacro to delete rowsvba excel pastespecialhello world vbaexcel 2010 nested if statementsaccess vba for loopmerge cells in excel 2007estimation excel sheetexcel vba clipboardamazing excel formulas