Copper Contributor

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  individually to pull the information? For reference this is how the master sheet looks like:

Screenshot 2023-11-01 035930.png

Thank you for the help guys!

1 Reply

@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.