Forum Discussion
Marshall1210
Mar 16, 2023Copper Contributor
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 ...
mtarler
Mar 16, 2023Silver Contributor
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 ...