Excel - The Intersection Operator

Ask a question


Introduction


The intersection function in Excel is useful while working with Excel worksheets. It calculates the intersection value of a column and a row in an Excel worksheet. One must know how to use the intersection function in Excel to add more functionality and features to your Office software. The Excel intersection function is important for presentations involving visual displays such as charts and graphs, to make the Excel worksheet look better and provide information in a clear way. The intersection function in Excel is so easy to use. A single line of code is required to enable the intersection function to work.
In a complex spreadsheet, it is often easier to reference cells using the headings of the column and row they are in, rather than using an absolute cell reference.

This can be done using the intersection operator, which is a empty space.

Example: This code returns the value of a single cell. In practice you can change column-title and row_title to suit your spreadsheet.
=column_title row_title

Note: Be sure to include the space between the column title and the row title.

You can reference multiple cells in this way. For example, the function to show a UK-based store's sales figures from January to March for shops in England might look like this:
=SUM(Jan:Mar England)
Jean-François Pillou

CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jeff Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.

Learn more about the CCM team

Related