I am looking to add cells together relative to one another. So for example I have a line of data say from cells A1 to A52 and for simplicity of explanation, lets say A1 = 1, A2 = 2, A3= 3 etc all the way up to A52. What I am trying to do on the line below is to sum these into weekly amounts. So I would sum (A1:A7) and the result would go in C1. I then want to sum (A8:A14) to go into C2 and (A15:A21) into C3 and so on. If I copy the calculation from C1 to C2 the cells are relative, so (A1:A7) would become (A2:A8) rather than as I want it to be (A8:A14), i.e. go up by 7 Can you copy a sum/formula to the next cell increasing the range you want to sum by 7
Hope this makes sense.
Hope this makes sense.