Navigation:  Formulas and functions > Functions from A to Z > INTERSECTION (intersection of two ranges)

Syntax:

INTERSECTION(Range1, Range2)

Description:

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

Note:

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

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

is identical to:

SUM(A1:D4 C3:E6).

Compatibility notes:

This function does not exist in Microsoft Excel. When you save a document in Excel format, all occurrences of this function will be automatically replaced by spacebar operators (see note above).

Example:

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