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

BROWSE ALL TEMPLATES

50+ Project Management Templates Pack
Excel PowerPoint Word

VIEW DETAILS

Advanced Project Plan & Portfolio Template
Excel Template

VIEW DETAILS

Ultimate Project Management Template
Excel Template

VIEW DETAILS

20+ Excel Project Management Pack
Excel Templates

VIEW DETAILS

20+ PowerPoint Project Management Pack
PowerPoint Templates

VIEW DETAILS

10+ MS Word Project Management Pack
Word Templates

VIEW DETAILS


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 - Get it Now!
Advanced Project Plan Excel Template

 
Related Resource External VBA Reference