# Creating yearly averages from monthly data in Excel

My ultimate goal is to graph yearly averages of my data. I have monthly data, and I would only like to return the average for each 12 month period.

``````PERIOD    MONTHLY     YEARLY AVERAGE
1         10
2         17
3         14
4         22
...
12        25          18
13        19
14        18
...
24        22          21
``````

This is what my data looks like, and I would like to create a yearly average for every 12 month period. I would only like a single value for each yearly average. Is there an easy way to do this?

• Yes, there are very easy ways to do this in Excel. What formulae have you already tried? Hint: AVERAGE() – Mike Fitzpatrick Jul 13 '15 at 6:07
• Yes, I have used AVERAGE(A2:A13), etc. The problem I have when I use that approach is all of the extra values that are included if I use fill->down with that equation. – jcronin Jul 13 '15 at 6:21
• Say your data starts on row 2, so the first year is rows 2-13. Put the year 1 value in C13. Select C2-C13, copy, paste into C14. Click End-Down Arrow to get to the bottom. Next cell, paste again. – fixer1234 Jul 13 '15 at 6:30
• Easier yet, select C2:C13 and drag down. – Scott Jul 13 '15 at 6:40
• The Data set is fairly large, so I am looking for a way to do this without having to do it seperately for each period. – jcronin Jul 13 '15 at 6:47

``````=IF(MOD(A13,12)=0,AVERAGE(B2:B13),"")