Hello. I am working on 10 production worksheets in one workbook for my team members (the worksheets I need to average are Rep 1 through Rep 10). I am trying to calculate a team rollup page, and forgot the formula that refers to the other worksheets. For example, I need to calculate the average of cell b6 for all ten reps (Rep 1 through Rep 10). Can anyone help me out here? Thanks a bunch!!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Rollup calculation (average of same cell# in 10 worksheets)
- Thread starter Shearman
- Start date
Gates Is Antichrist
Well-known Member
- Joined
- Aug 15, 2002
- Messages
- 1,961
=AVERAGE(Sheet1:Sheet10!B6)
This requires more discipline than your everyday formula. The 10 sheets must be consecutive - or rather, contiguous - and bounded by the two named in the formula. If any sheets are ever inserted or deleted within there, beware. If more are added outside the existing boundary, beware.
This requires more discipline than your everyday formula. The 10 sheets must be consecutive - or rather, contiguous - and bounded by the two named in the formula. If any sheets are ever inserted or deleted within there, beware. If more are added outside the existing boundary, beware.
Upvote
0
Similar threads
- Solved
- Question
