Automatic Addition of Numbers Help

**lydiakim91** · 06-19-2012, 11:29 PM

Hi! I'm new to this forum.

I have a question regarding the automatic add.
I just started making a home budget spreadsheet and had trouble trying to the total money earned by week. I know that by dragging the lower left corner of a box, I can make the program automatically add the numbers. My questions is if the automatic number goes to the next 6 numbers rather than the immediate next. Probably sounds confusing so I will try to explain by examples.

#1
#2
#3
#4
#5
#6
#7
....
#12
#13

So I want to add the first 6 numbers =SUM(#1,#6)
When I drag the box down, I want it to be =SUM(#7,#12) instead of =SUM(#2,#8).
Is there any way to do this automatically or do I have to manually put it in?
I would be so thankful!

**canapone** · 06-19-2012, 11:42 PM

Hi,

this example sums A1:A6, A7:A12, A13:A18 ...

=SUM(INDIRECT("A"&ROW(A1)*6-5&":A"&ROW(A1)*6))

Hope it helps

**MarvinP** · 06-20-2012, 12:11 AM

Hi and welcome to the forum,

On the attached workbook, simply select all the yellow cells and double click on the bottom right corner of that selected area. It will fill in all your formulas.