Unlike SUMIF, the formula SUMIFS is able to handle multiple criteria and multiple lookup ranges to sum for a given condition, for this case we have two criteria and two lookup ranges to get the final sum.
An Example of SUMIFS with multiple criteria
Nested sumif to get the final sum
Sumif example for more then one criteria
Category: Math and trigonometry
Adds the cells in a range that meet multiple criteria
SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
Create a new account
I already have an account
You haven't saved the current formula!
Are you sure to continue?
You haven't save the current formula!
Made with in Istanbul
START LEARNING EXCEL with SHEETZOOM