How to add equivalent cells across tabs in Excel

This particular technique allows you to add equivalent cells across different tabs within Excel. In our example, we use a scenario where a Christmas tree business wants to aggregate sales reported from two different locations (in two different tabs).

In order to do this, you need to setup blank tabs and place them either side of the tabs which you want to aggregate. For this example, I named these tabs ‘>>>’ and ‘<<<’.

Next, setup a separate tab in which you will insert the formula.

The formula used is =SUM(‘>>>:<<<’!D6)

This adds the individual cell D6 in all tabs in between the tabs named >>> and <<<. In our example, this includes two tabs; ‘Sales – London’ and ‘Sales – Manchester’.

Download Excel File

 Adding cells across tabs example

Comments (No)

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.