Union and Intersect Operator in Excel

In this post,you will learn what is Union and Intersect operator in Excel and how to use them in your Excel spreadsheet.

Union operator simply adds two range of cells. Intersect Operator gives the intersection of two ranges.

Union Operator in Excel

The symbol , (comma) represents the union operator. So when you insert this symbol in between the function it gives you the sum of it.

Union Operator in Excel

You can see the result in the below screenshot.

Union Operator in Excel

Intersect Operator in Excel

A white space represents this operator. For instance, when you insert a space in the function between the range. The function gets executed but only within the common range.

Let’s take a look at an example.

Intersect Operator in Excel

Here the intersection in the range is cell B2 and C2, so the sum is calculated from them.

Intersect Operator in Excel

So to the end, this is how you implement it.