The SUMIFS function can take more then one criteria as an argument, thus we can look for them in a single formula that gives us the final count. We usually use logical operators for such comparisons.
Sumif example for more then one criteria
How to do sum with sumif and 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