The SUMIFS Formula takes as many as 127 arguments for criteria and lookup range making it easy to sum against multiple criteria. For just 02 ranges we need to put the second criteria argument only twice and leave the additional arguments.
Sumif with 2 criteria for calculating sum
Formula for sumif with two conditions
An Example of SUMIFS with multiple 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