SUMIF Function in Excel
How to use SUMIF function in Excel?
The
SUMIF
function in Excel adds all numbers in a range that meet a specific criterion. We can use it by using the following syntax:SUMIF(range, criteria, [sum_range])
.
- range: the cells you evaluate with the criteria.
- criteria: the condition that determines which cells to add.
- sum_range (optional): the cells to sum. If omitted, Excel sums the cells in
range
.
Why use SUMIF instead of sum?
SUMIF allows you to sum values that meet specific criteria, while SUM sums all values in a range.
What is the alternative to the SUMIF Function?
The alternative to the SUMIF function is the SUMIFS function, which allows for multiple criteria.
SUMIF Function in Excel with Examples
Excel is a great tool to use in data collection and entry and nowadays it is widely used worldwide. To make the tasks of data management easier Excel has some built-in functions and formulas. SUMIF is such a function. This function easily sums the particular numbers in a large dataset. This is a worksheet function and comes under the Math & Trigonometry function.
This function does exactly what its name indicates. Using this function we can get the ‘SUM’ of numbers of a particular range ‘IF’ the given criteria are satisfied. This function evaluates the sum of a particular range applying a condition. In this function, we can apply criteria to one range and sum up another range according to the criteria.