SUMIFS Function In Excel | Advance Excel Course

SUMIFS is another Excel function that allows you to sum up the values in a range of cells based on multiple criteria. This function is useful when you need to sum up values that meet more than one condition.

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

The syntax for SUMIFS function is as follows:

=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

• sum_range: the range of cells that you want to add up.

• criteria_range1: the first range of cells that you want to evaluate.

• criteria1: the first condition that must be met for a cell to be included in the sum.

• [criteria_range2, criteria2]: additional ranges and conditions that must be met for a cell to be included in the sum. You can include up to 127 ranges and criteria.