3D link in Excel

A 3D link in Excel refers to the same cell or range on multiple sheets at once. Let’s start with an alternative:

1. 1. On the “Company” sheet, select the cell B2 and enter the equal sign “=”.

1. Go to the “North” sheet, select the cell B2 and enter “+”.
2. Repeat step 2 for the “Mid” and “South” sheet. Result:
3. Agree, there is a lot of work. Can be used instead as an argument to a function SUM (SUM) the following 3D link: North:South!B2.

   =SUM(North:South!B2)

   =СУММ(North:South!B2)

   

4. If you add another sheet between “North” and “South”, it will automatically enter the formula: