How to use Union and Intersect operators in Excel

by

This example illustrates how to use the union and intersect operator (borders below for illustration only) in Excel.

Worked Example:   Simple Excel Formulas and Functions

1. The union operator (comma) adds two ranges.

Explanation: the SUM function reduces to =SUM(C4:D8) + SUM(D7:E11), 20.

Worked Example:   Simple Excel Formulas and Functions

2. The intersect operator (single space) returns the intersection of two ranges.

Worked Example:   Simple Excel Formulas and Functions

Explanation: the SUM function reduces to =SUM(D7:D8), 2.

Leave a Reply

Your email address will not be published. Required fields are marked *