Excel help

[gabbiadini1]

Hi. I need to figure out my income over rolling 12 month periods.
I have all the data ready but unsure how to get excel to do what I want.
I’m sure there is a very easy way, but looking online and I’m more confused than before lol!
Anyone know of a template available to do this task?
Thanks in advance

 

[42]

=SUM() with the cells you need to add to in the brackets. Then when you copy the formula along it'll adjust for the next 12 months

 

[RestlessNatives]

May have misunderstood but assuming you have totals per month as shown in image.
Then cell L3 is =SUM(A2:L2) then drag that along so M3 is =SUM(B2:M2) etc

 

[gabbiadini1]

Fantastic. Many thanks!

 

[Sporty]

May have misunderstood but assuming you have totals per month as shown in image.
Then cell L3 is =SUM(A2:L2) then drag that along so M3 is =SUM(B2:M2) etc
View attachment 14847

You been raking my payslips outta my bins?

 

[Goat Eyes]

It just sounds like some simple addition. Would a calculator not do?

Haway Gabbers.

 

[gabbiadini1]

Thanks @42 and @RestlessNatives i just did it and it worked! Thanks. I can’t believe I managed to get it to work
it’s the rolling matter lol! Obviously could do with a bit of paper and pencil, but I’ve got it to work now so all good!