Forum Discussion
Computing the average of numbers across multiple worksheets for an item in Sheet 1
I have an Excel Workbook that has a Summary Sheet (Sheet 1) and then 19 other sheets, each representing a year from 2000-2018. Each sheet contains the following columns: 1) Ranking 2) Manager/Team ...
To give credit to whom it is due, I learned the 3D Formula trick from Microsoft Excel MVP Bob Umlas, particularly Tip No. 85 on page 166 of his book: This isn't Excel, it's Magic!