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

find duplicates excelsave excel file as xmlsas programming tutorial pdfpivots excelfso.copyfileautofit row height not workingadding title to excel chartexcel vba active cellexcel vba interfacecollection in vbams excel 2007 formulas with examples pdf in hindimultiple if conditions in excelhow to remove protection from excel sheet 2007vba applicationshow lock excel sheetmacros in vbexcel find duplicate recordsexcel 2007 paste specialproject management spreadsheet excel templateexcel tutorials advancedhow to use datevalue function in excelcreate form vbahow to unhide rows in excel 2013sumif example excelmicrosoft excel graph tutorialhow to prepare dashboard in excellookup table excel 2010excel and macrosdcl databaseif statements in excel 2010macros and vbamicrosoft excel macroshow to unhide rows and columns in excel 2010how do i unhide a column in excelexcel vba color indexexcel vba collectionactiveworkbook.saveas filenamehow to unlock protected cells in excelcreating a pivot table in excel 2007vba msgbox syntaxexcel macro creationsql ddl dml dcl tcl commands pdfschedule template for excellink sql to excelcheckboxes in excelms excel vlookup examplevba stophow to open xml file in excel 2007excel remove duplicates from multiple columnscommands of ddlvba file pathmerge and center the selected cellsformula to hide rows in excelvba cell selectioninserting lines in excelhow to insert a hyperlink in excelexcel dashboards templatesvlookup excel 2007 tutorialvba sampleexcel hlookup formulahow to unprotect excel workbook without knowing passwordmicrosoft excel estimate templatevba query databasevba step by step runmsgbox syntaxopen file with vbaexcel macro copy sheetexcel 2007 lookupsort highest to lowest excelhow to insert tick mark in excel 2007excel pivot table auto refreshcombobox excelwhere is developer tab in excelvba open text filehow to delete duplicates in excel 2013