Birdsville Author

Level 1

9 points

Data from multiple sheets

I have 30+ sheets in my spreadsheet. I created the formula show below to lookup the data and add it all up in a "summary" sheet. Example below covers just two sheets of my 30+

This works and I get the result, but I am also hoping that there might be a way to reference all sheets without doing it one by one. Relevant data is in the same columns in each sheet.

Posted on Sep 25, 2020 11:26 PM

Reply

Similar questions

Summary of multiple sheets formula Hi, would somebody be so kind to help. I have a numbers document which will eventually have multiple sheets, sheets will be exactly the same representing job summaries as I will duplicate as jobs come in. I would like to have a main summary sheet totalling data from jobs sheets as they’re added. I have wondered if somehow an indirect function would do this but can’t get my head around it. Any help would be greatly appreciated.
1835 2
sum of cells from different sheets how can I insert a sum of cells from different sheets? I use numbers as a warehouse control and I have different sheets depending on the brands. I would like to automatically add some cells to each sheet
620 1

2 replies

Level 7

22,213 points

Sep 26, 2020 3:43 AM in response to Birdsville

Hi Birdsville,

You can do this by creating cell addresses for the function INDIRECT to "pull" the data you want to look up.

Formula in E2: "Sheet "&A2&"::Table "&B2&"::"&C2&D2

Formula in F2: INDIRECT(E2)

This is a clunky approach. Perhaps another user will step in with a better method.

Good luck!

Ian.

Reply

Birdsville Author

Level 1

9 points

Sep 26, 2020 4:42 AM in response to Yellowbox

Actually, this could be helpful Ian. I may already have a table containing a list of sheets - thanks for the tip!

Reply

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Data from multiple sheets

Welcome to Apple Support Community

A forum where Apple customers help each other with their products. Get started with your Apple Account.

Learn more Sign up