intersection operator

  • Thread starter Thread starter Mike King
  • Start date Start date
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!
 
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.
 
Thanks for the quick response and conformation!

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum of the intersect of two named ranges 5
Write to intersect of a row and column 7
Trying to run excel vba code when cell value changes from empty to entered value. 1
Empty cell warning 3
Intersection Referene Operator 8
Determine Intersection of 2 lines using Excel VBA 0
Data Validation and drop-down list using IF, AND and what else? 8
Data tables ? Circular references ? 1

Back
Top