Hi. I have monthly data that I would like to convert into yearly data, so I can plot a smoother graph with less points.
So the formula is pretty simple, but I tried filling it for 3 years and then dragging the formula, but it doesn"t work correctly.
The formula I typed in F7 is
=sum(B29:B40), and I want the formula in the next cell F8 to be
=sum(B41, B52), but when dragging the formula it puts
=SUM(B8:B19) (so it takes the first fomula in F5
=SUM(B5:B16) and adds one for each column, instead of adding 12)
Is there an automated way to achieve what I want?
Alternatively, is there a way to plot ever 12th data point?