Skip to content

The Intersect Operator in Excel

In this article, I will show you how to use the intersect operator in Excel.

What Is the Intersect Operator?

The intersect operator is a single space placed between two ranges.

The intersect operator returns the intersecting cells of the two cell ranges.

For example, take the range B2:D4.

Now take the range C3:E5.

Using the intersect operator on these two ranges would give you the intersecting cells, which is the range C3:D4.

Intersect Operator Example

Let’s say you want to add the numbers in the intersecting cells between the ranges B2:D4 and C3:E5.

You would use the SUM function along with the intersect operator. Your formula would look like this.

=SUM(B2:D4 C3:E5)

The intersect operator returns the intersecting range, and the SUM function adds together the numbers in that range.

=SUM(C3:D4)

And that is how to use the intersect operator in Excel.

This Post Has 0 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top