How do have a formula change as hte worksheet changes,

May 3, 2018
2
0
10
0
=round(average(Week1:Week4!E2:E24),2) is in worksheet 4 when I move it to worksheet 5 should be Week2:Week5
 
It is very hard to create "automatic" forlumales where sheet names are involved. So, create a new sheet, put it in front of the others. In that sheet, put links to a cell(s) in each sheet where raw data exists, then create averages using the data in this single sheet.
 
Thread starter Similar threads Forum Replies Date
S Apps General Discussion 5
M Apps General Discussion 6
H Apps General Discussion 13
U Apps General Discussion 1
M Apps General Discussion 4
N Apps General Discussion 7
P Apps General Discussion 1
P Apps General Discussion 4
D Apps General Discussion 2
W Apps General Discussion 2
J Apps General Discussion 2
Z Apps General Discussion 2
S Apps General Discussion 1
C Apps General Discussion 7
S Apps General Discussion 3
B Apps General Discussion 4
M Apps General Discussion 11
indyitguy Apps General Discussion 8
wanamingo Apps General Discussion 1
Christopher Chung Apps General Discussion 4

ASK THE COMMUNITY