Forum Discussion

Marshall1210's avatar
Marshall1210
Copper Contributor
Mar 16, 2023

Excel Sum Formula

 

Hello Everyone I am looking to get a formula that would pull data from the same cell on multiple tabs even if I add more tabs.

 

I have set up 2 tabs called bookend 1 & bookend 2. Between these bookends I will be adding client tabs that have certain data I want to collect and bring back to a tab called Master. 

 

All the tabs are copies of each other so the data would be located in the same cel (row and column) on each tab.

excel
Formulas and Functions

1 Reply

Sort By
  • mtarler's avatar
    mtarler
    Silver Contributor
    Mar 16, 2023
    There are only certain functions that work with "3D references". For example SUM('bookend 1:bookend 2'!A1) would work but many other functions like lookups and others do NOT work. One neat trick is that you can use concatenate and TEXTJOIN so you could 'join' the cells and then TEXTSPLIT to create an array you can work with ...

Resources