0
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.
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
By signing in/up, you agree to the Terms of Use and Privacy Policy.
You haven't saved the current formula!
Are you sure to continue?
You haven't save the current formula!
0
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.