SUMIF Function in Excel | Advance Excel Course

SUMIF is an Excel function that adds up the values in a range of cells based on a specific condition. This function is very useful when you need to sum up only those values in a range that meet a certain criteria.

For example, let's say you have a list of sales figures for different products, and you want to find out the total sales for a specific product. You can use the SUMIF function to add up only the sales figures for that particular product:

The syntax for SUMIF function is as follows:
=SUMIF(range, criteria, [sum_range])

• range: the range of cells you want to evaluate
• criteria: the condition that must be met for a cell to be included in the sum. This can be a number, text, or logical expression.

• sum_range (optional): the range of cells that you want to add up. If this argument is omitted, the function will add up the values in the range specified by the 'range' argument.