Marking cells in 52 worksheets

R

RayD

Hello,

Seems as though I did this a few years ago but don't remember the
trick to do it again!

I have 52 worksheets and 1 Summary sheet that will take the weekly
average from each of the 52 worksheet and keep it in the Summary
worksheet for quick reference.

Question is, in the Summary worksheet how do I create an "average"
formula that will cover one cell in each of the 52 worksheets?

Any help would be appreciated.

...Rcd
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Match with 3 criteria 3
Index, Match, Lookup, Vlookup or Combination? 1
Lookup in multple worksheets 5
min,average>0 if 52 cells read zero 2
Relative worksheet reference clarified 4
changing worksheet reference name when copying down cells 5
Cell Referencing 5
Trying to average the contents of a cell across multiple worksheet 12

Top