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
U Apps General Discussion 1
D Apps General Discussion 2
J Apps General Discussion 2
S Apps General Discussion 1
C Apps General Discussion 7
S Apps General Discussion 3
B Apps General Discussion 4
wanamingo Apps General Discussion 1
GOM3RPLY3R Apps General Discussion 6
J Apps General Discussion 5
gamerxavier Apps General Discussion 5
S Apps General Discussion 4
M Apps General Discussion 1
E Apps General Discussion 12
G Apps General Discussion 1
E Apps General Discussion 3
nekulturny Apps General Discussion 2
ulillillia Apps General Discussion 12

Similar threads


ASK THE COMMUNITY