Hello, I am trying to have a running average of a particular cell across a range of sheets that grows.
I'm using this formula =SUM('1:1 (9)'!I17)/(SHEETS()-2)
I'm copying the last sheet in each day so will be creating 1 (10), 1 (11), etc.
I want to have this formula on the first sheet 1 and copy that sheet each day of the month 1 (2), 1 (3), etc. so the formula will show the running average of the cell in all the sheets that have been created.