Excel - The Intersection Operator

October 2016


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 :

This document entitled « Excel - The Intersection Operator » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.