# intersection operator

*From*: "Mike King" <emailMK@xxxxxxxxxx>*Date*: Wed, 25 Jan 2006 10:38:26 -0500

I'm trying to understand the intersection operator in Excel. Can someone

tell me if the following is true. The intersection operator (the space

character) finds the intersection of two sets of cells not values. For

example, in the example below one cannot find the intersection of A1:A3 and

B1:B2 because the cells don't intersection even though the values do.

A B

1 1

2 2

3

=SUM(A1:A3 B1:B2) equals #NULL!

.

**Follow-Ups**:**Re: intersection operator***From:*Niek Otten

- Prev by Date:
**Re: Excel and adding cells items...** - Next by Date:
**Re: conditional formating?** - Previous by thread:
**Excel and adding cells items...** - Next by thread:
**Re: intersection operator** - Index(es):