Excel: Chapter 1: Lesson 10 - Union and Intersect

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.