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.

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

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

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

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

Leave a Reply

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