INTERSECTION (intersection of two ranges)

<< Click to Display Table of Contents >>

INTERSECTION (intersection of two ranges)

Syntax:

INTERSECTION(Range1, Range2)

Description:

Returns a reference to the intersection of Range1 and Range2 (i.e. the cell range where Range1 and Range2 overlap).

Annotation:

Alternatively, you can use the spacebar operator to obtain the intersection of two ranges. For example:

SUM(INTERSECTION(A1:D4, C3:E6))

is identical to:

SUM(A1:D4 C3:E6).

Compatibility notes:

This function is not supported by Microsoft Excel. When you save a document in Excel format, PlanMaker will automatically replace all occurrences of this function by spacebar operators (see annotation above).

Example:

INTERSECTION(A1:D4, C3:E6) returns a reference to the range C3:D4