When specifying function arguments, if you put a space between two ranges, the space operates as an intersection operator. Episode 691 ponders what uses our viewers might have for this operator.
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!
Transcript of the video:
Welcome back to the MrExcel netcast.
I'm Bill Jelen.
Today, we have a question about the Intersection Operator, and this is something frankly I hardly ever use you know usually, if we have a series of ranges, so we can add up this range and then we put a comma and add up this range.
The comma they say is a union operator It joins you know whichever two ranges you have.
Okay good enough, but there's a weird variant of this called the Intersection Operator.
Where we say okay.
We want to take this range, and then I don't put a comma I put a space and specify another range.
So, I'll specify this range here and basically, what happens is we get the total of only the cells that are in both ranges, only the cells that are in both ranges.
So, in that case that should be 45 plus 80 should get 125, and we do the Intersection Operator used you know, basically a space.
If you have a reason that you used this, I'd love to hear about it.
Drop me a note bill@mrexcel.com and let me know and we'll get to you on a future podcast.
Uses for the Intersection Operator.
I wanna thank you for dropping by.
And we'll see you next time for another netcast from MrExcel.
I'm Bill Jelen.
Today, we have a question about the Intersection Operator, and this is something frankly I hardly ever use you know usually, if we have a series of ranges, so we can add up this range and then we put a comma and add up this range.
The comma they say is a union operator It joins you know whichever two ranges you have.
Okay good enough, but there's a weird variant of this called the Intersection Operator.
Where we say okay.
We want to take this range, and then I don't put a comma I put a space and specify another range.
So, I'll specify this range here and basically, what happens is we get the total of only the cells that are in both ranges, only the cells that are in both ranges.
So, in that case that should be 45 plus 80 should get 125, and we do the Intersection Operator used you know, basically a space.
If you have a reason that you used this, I'd love to hear about it.
Drop me a note bill@mrexcel.com and let me know and we'll get to you on a future podcast.
Uses for the Intersection Operator.
I wanna thank you for dropping by.
And we'll see you next time for another netcast from MrExcel.
