SUMIFS has ability to take more then one argument as criteria and look into multiple ranges to check for that criteria. Thus when we ant to use two criteria, we will set two arguments for criteria with two lookup ranges to get the final count.
An Example of Sumifs criteria
Getting sum with SUMIF() with two criteria
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