by 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
Syntax
=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)
Arguments
• 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.
