Average throughout the sheets

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

Hi All,

If I have 16 sheets and then I have a summary sheets....now in Cell B2 of
summary sheets I need to take the average of cell B2 in all the
sheets......what is the easiest way?

if the sheet tabs are named as Agent 1........Agent 16, can it be something
like =AVERAGE(Agent 1:Agent 16,B2)

Any help will be appreciated
Thanks
gary
 
=AVERAGE(Agent1:Agent16!A1)

The above averages the content of A1 in sheets 1 to 16
 
You must log in or register to reply here.

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

Average throughout the sheets 3
Dependent drop down dynamic range formula, off sheet. 7
AVERAGE NON-ZERO CELLS ACROSS SEVERAL WORKSHEETS IN SAME WORKBOOK 7
Copy to another worksheet IF 3
Update cell value based on name and specific date 1
Average across selected worksheets 1
INDIRECT reference to another worksheet in same workbook 4
averaging from different sheets and folders 1

Back
Top