<< 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