Average over multiple worksheets

drivinatwork

New Member
Joined
Feb 20, 2013
Messages
6
Looking to get the average of a single cell over multiple worksheets, but I need it to always go to the last worksheet as I will be adding more sheets.

[FONT=&quot]=AVERAGE(Sheet1:????!A1)[/FONT]

Thanks
 

StephenCrump

Well-known Member
Joined
Sep 18, 2013
Messages
3,567
Why not put a blank sheet at the end of the workbook, and insert your new worksheets in front of this.

Then you can use =AVERAGE(Sheet1:LastSheet!A1)
 

Forum statistics

Threads
1,085,888
Messages
5,386,572
Members
402,006
Latest member
stringer47

Some videos you may like

This Week's Hot Topics

Top