Excel - The Intersection Operator

February 2017



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)

Related


Published by jak58. Latest update on October 3, 2012 at 08:07 AM by deri58.
This document, titled "Excel - The Intersection Operator," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).