Solution

The formula to be used when you need to add all the values in a column based on more than one condition is SUMIFS.

 

• SUMIFS allows you to sum the values in a range that meet multiple criteria. It can handle more than one condition, making it ideal for situations where you need to filter and sum data based on several conditions.

For example, if you have a column of sales data and want to sum only the sales for a specific product in a specific region, you would use the SUMIFS function.

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