intersection operator

M

Mike King

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

Niek Otten

Indeed it is the intersection of (address) ranges. Look at the spreadsheet
grid, highlight the ranges and you don't see an intersection in your
example.
 
M

Mike King

Thanks for the quick response and conformation!

Is there a way of finding the intersection of values not ranges?
 
Top