In this article, we are going to learn how to total two ranges using SUMIF formula in Microsoft Excel.
To let the SUMIF formula add or subtract amounts from different ranges, insert two SUMIF formulas and combine them into a single formula.
Let’s take an example and understand:-
We have an agency’s car sales data. In data, we have sales details along with discount detail. Now, we want to calculate the sum for every manufacturer sales amount and discount amount.
How to total two ranges using SUMIF formula?
To total the positive numbers and negative, we will use SUMIF function. We need to follow below given steps:-
Formula Explanation: -
This syntax “=SUMIF($A$2:$F$17,$H2,$E$2:$E$17)” will return total sum of purchase amount to every manufacturer.
“SUMIF($A$2:$F$17,$H2,$F$2:$F$17)” will return total sum of discount amount to every manufacturer.
And then we add the both amount.
This is the way we can total two ranges by using SUMIF function in Microsoft Excel.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.