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

how to protect sheets in excelpassword log template excelmsgbox yes no vbavba access create tablevlookup tutorialhow to unhide excel columnscolour index excelvba reference guideprotect excel sheet from editingxls to xml conversionexcel duplicate entrieshow to use advanced filter in excel 2010protect formulas in excelfso filehow to create project timeline in excelcreate excel userformappend in excelvba shortcut keysshow hidden columns in excelexcel dashboard samplesalphabetical order in excelexcel checkbox cellsumif excel formulaexcel vba odbc connection stringexcel macro to copy data from one workbook to anothercut and paste workbookseasy vlookup exampleexcel macro formmicrosoft excel coding tutorialexcel macro basicssample excel macro codeexcel 2003 find duplicatesvba excel formvba runtime error 1004 application defined or object defined errorduplicate entries in excelbox plot excel 2010 templatedelete a row in excel vbaexcel vba formattinggantt chart excel 2003interview questions on testing for fresherscheckbox vba excelexcel sumif functiondata definition language ddl commandexcel logical functions with examplesmultiple if functions in excel 2010vba templatesexcel vba list files in foldervba excel copyexcel formulas and examplesunprotect an excel fileexcel 2010 sumif functionexcel 2007 sort by datehide cells in excelexcel vba formula in cellexcel string containshow to delete repeated rows in excelshortcut key insert row exceltask excel templatevba excel bordersvba excel color cellhow to protect sheets in excelhow to create dashboards in excelvba forms in excelexcel vba variablesms excel concatenatesql questions and answers pdfcopy cells in excelhow to delete duplicate items in excelmacro remove blank rowsvba run commandexcel look for duplicatessumif syntax