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.
Thank you for your help!
For some reason I cannot make the helper column. When I do =YEAR(D2) it returns 1905 rather than 1960. This is so strange and frustrating.