SOLVED

How to turn a monthly list of prices into a yearly list of average annual price.

Copper Contributor

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 have yearly data. Trying to use averagifs but I must be missing something. Also formatting of column D is general as when I try to format as yyy it only returns 1905 for some reason. Screenshot 2022-04-12 at 09.40.53.png

3 Replies
best response confirmed by LeoHink (Copper Contributor)
Solution

@LeoHink 

=AVERAGEIFS($B$2:$B$214,$C$2:$C$214,D2)

I would add a helper column along with the above formula.

@OliverScheurich 

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. 

I figured it out actually thank you very much! works a charm
1 best response

Accepted Solutions
best response confirmed by LeoHink (Copper Contributor)
Solution

@LeoHink 

=AVERAGEIFS($B$2:$B$214,$C$2:$C$214,D2)

I would add a helper column along with the above formula.

View solution in original post