Best way to calculate data across 100 sheets with same structure
Working on a project that will have 100 or so sheets with exact same structure. I need an efficient way to be able to calculate data SUM, COUNTS, AVG across 100 sheets in one metric sheet. What is the best way to accomplish this without the need to reference each individual sheet? Is there a way to run metrics on a report that pulls all the sheets together in one view? Other?
My backup plan is to combine (copy paste) all 100 sheet at some point when data entry mapping is complete and then run my variables against it.
Help Article Resources
Check out the Formula Handbook template!