How do have a formula change as hte worksheet changes,

Status
Not open for further replies.
May 3, 2018
2
0
10
=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.
 
Status
Not open for further replies.