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

PREMIUM TEMPLATES LIMITED TIME OFFER

ON SALE80% OFF

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

Reference:

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

LIMITED TIME OFFER
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


macros excel 2003vba string starts withcost estimation software free downloadhow to enable developer tab in excelvba public variablesorting an excel spreadsheetexcel isrefsumif excel examplepivot table samplesdim fso as filesystemobjectpv table exceluseful vbahow to unhide all in excelunlock protected excel workbookloop in excel macromicrosoft word project plan templatevertical lookup excel 2007what are the shortcut keys in ms excelprotect an excel workbookgantt chart free downloadprotect sheet vbatask planner templateexcel task tracking templatevb adoexamples of formulas in excelexcel vba cell offsetembed forms.combobox.1excel appendexcel vba deletestacked line graph excelhow to use nested if function in excel 2010meeting minutes template excel formatset activesheetvba lock cellsunlock password excelhow to unprotect excel without passwordvba interview questionmerge columns exceldelete duplicate records in excelisevendouble if statement excellocking a spreadsheeth lookup functionproject weekly status report template pptms access vba tutorial pdfexcel concatenationexcel vba this worksheetcount cells in vbavba save excelvba activesheet shapesworksheet activatevbscript example programsremove unused cells in excelsql questions asked in interviewmacro delete blank rowswhat is the developer tab in wordcreate pivot in excellist of excel shortcut keyscustom messageboxhow to use vlookup excel 2013filter excel vbamacro excel rangesimple excel exercises for beginnerslooping in vbasql query questions and answers pdfexcel vba tutorialarrange numbers in ascending order in excelvbscript examples in notepadmerge excel worksheets without copying and pastingworksheet function vbadefinition of worksheet in excelmake a drop down list in excel 2007form controls vs activex controls