I would like to do averaging across sheets. Assume that I have sheets named A,B,C and I want to average cell B12 over all sheets. I managed to find the formula (which works):
=AVERAGE(A:C!B12)
Now I would like to do it parametric, i.e I want to put the name of the last sheet in cell B2 so when I add another sheet (sheet D), the only thing I need to do is to change B2 (because the averaging should now go from sheets A to D).
I've tried to use the INDIRECT function but for some reason it does not work.
=AVERAGE(INDIRECT("'A:"&$B$2&"'!"&B12))
Any ideas?
Thanks in advance!