MichelGagnon
New Member
- Joined
- Oct 19, 2017
- Messages
- 6
I have multiple sheets all named with a year. I have a last sheet called average.
I have found a way to average all the years into an exact same table on that last sheet.
=AVERAGE('2016:2020'!B4)
Now I am trying to use indirect to get the value of two cells so that I can easily change the years calculated. Now the formula that I have found only averages the first and last year.
=AVERAGE(INDIRECT("'"&M27:M28&"'!"&"B4"))
What am I missing?
I have found a way to average all the years into an exact same table on that last sheet.
=AVERAGE('2016:2020'!B4)
Now I am trying to use indirect to get the value of two cells so that I can easily change the years calculated. Now the formula that I have found only averages the first and last year.
=AVERAGE(INDIRECT("'"&M27:M28&"'!"&"B4"))
What am I missing?