Union and Intersect Ranges in Excel

This example shows how to get the union and intersection of two ranges in Excel. The borders in the figure below are for illustrative purposes only.

1. Use a comma to get the union of two ranges.Explanation: Function SUM (SUM) is reduced to

   = SUM(C4:D8) + SUM(D7:E11)

   = СУММ(C4:D8) + СУММ(D7:E11), т.е. 20.

2. Use a space to get the intersection of two ranges.Explanation: Function SUM (SUM) is reduced to

   = SUM(D7:D8)

   = СУММ(D7:D8), т.е. 2.