What is the use of SUMIF function?
SUMIF Function in Excel adds all numbers in a range based on a given criteria
What is the syntax of SUMIF function?
SUMIF( range, criteria,
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
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
Save Up to 85% LIMITED TIME OFFER
A Powerful & Multi-purpose Templates for project management. Now seamlessly manage your projects, tasks, meetings, presentations, teams, customers, stakeholders and time. This page describes all the amazing new features and options that come with our premium templates.
