Hi all,

I have, what I think should be an easy problem to fix, I just haven't figured it out.

I have a row of quarterly data that I would like to turn into annual data. When I put the formula =Sum(A1:A4) It turns the first 4 quarters into one year.

The issue is one I copy and paste it into the next cell it becomes =Sum(A2:A5), when I want it to be =Sum(A5:A8).

Is there a way to excel to do that automatically without me having to rewrite the formula everytime?

Thanks