A couple of rarely used features of worksheet formulas are Unions and Intersects.

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.