I'm using the formula below to average a specific cell (c6) across a number of worksheets. There is 1 sheet per week of the year (1-52)
e.g. =AVERAGE('Week 1:Week 4'!$C$6)
My problem is I want the sheet number to be variable so I can change it to say weeks 20:30 by typing the values 20 and 30 into cells in a worksheet called "selection" where b1 would be 20 and b2 would be 30.
Just can't seem to get it to work! any thoughts on what the formula should be?
Perfect & Thanks very much for your time, got both to work today and will probably go with the first as although it looks more complicated will probably be more flexible. I do appreciate your time, Work longer on Wed.s and only just got back in.