Forum Discussion
Solved
How to turn a monthly list of prices into a yearly list of average annual price.
Please see the screenshot below. I'm trying to match up two lists one has the monthly price and the other is a yearly inflation rate. I'm trying to take the annual average of column B so that I only ...
=AVERAGEIFS($B$2:$B$214,$C$2:$C$214,D2)I would add a helper column along with the above formula.
=AVERAGEIFS($B$2:$B$214,$C$2:$C$214,D2)I would add a helper column along with the above formula.
I figured it out actually thank you very much! works a charm