Forum Discussion
Formula
Is there a way we can pop a formula on each tab that calculates the number of associates trained that week along with the average percentage of assessment scores without having to go through each tab...
AK_SEHGAL97 You could use the INDIRECT function for that, but your problem is a structure problem.
If you want to easily summarize data it is best to have like data on the same tab in a single table. Add a column to the table which contains the current tab name (such as a company name or a department). Now you can use a pivot table to summarize your data.