I have a list of excel table names (each table layout is identical) and I want to write a formula within another identically formatted table that will return the sum of each table's value in that corresponding cell. The list of table names will be in its own range. The tables listed can change and the total number of listed tables can also change. What's the best way to go about accomplishing this? Preferably formula and not VBA.
Thank you,
kb
Bookmarks