Apr 12 2022 01:47 AM
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.
Apr 12 2022 02:53 AM
Solution=AVERAGEIFS($B$2:$B$214,$C$2:$C$214,D2)
I would add a helper column along with the above formula.
Apr 12 2022 03:10 AM
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.
Apr 12 2022 03:15 AM
Apr 12 2022 02:53 AM
Solution=AVERAGEIFS($B$2:$B$214,$C$2:$C$214,D2)
I would add a helper column along with the above formula.