Union Function in Excel

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 sets of values

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

sum of two sets

The above function sum up both the overlapping values twice.