Union in MS Excel
The term Union refers to apply a SUM function to a multiple range in an additive nature.
To have a better understanding of the concept, follow the steps below:
1. For this example, consider a scenario that there are 2 sets of values that are needed to be added collectively and they are having 2 overlapping cells which will be considered as part of both sets:
2. Now, in order to sum both sets at one place, enter the SUM function having Cell range of Set 1 and Cell range of Set 2, both separated by a “comma” symbol.
3. The output of both sets would be the sum of all values residing within them
The above function sum up both the overlapping values twice.