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.

Shortcodes Ultimate

Follow Us