Copy/Fill increments

[tcidawn]

I have data in cells 1 – 297 in a worksheet that I want totaled in new
workbook like so…

Row 1 @sum(A1:A5)
Row 2 @sum(A6:A10)
Row 3 @sum(A11:A15) Etc.

When I enter the formula in the first cell of the new workbook and copy the
data down, it fills in increments of 1 instead of increments of 5

Row 1 @sum(A1:A5)
Row 2 @sum(A2:A6)
Row 3 @sum(A3:A7)

 

[Jacob Skaria]

In row 1 use this formula; and copy that down

=SUM(INDIRECT("A"&(ROW()-1)*5+1&":A"&ROW()*5))

If this post helps click Yes

 

[tcidawn]

Jacob,

My results were 0 with the formula as stated.

Dawn

 

[Jacob Skaria]

From A1 to A5 fill 1
From A5 to A10 fill 2
From A11 to A15 fill 3

The below formula in B1 should give you a total of 5
=SUM(INDIRECT("A"&(ROW()-1)*5+1&":A"&ROW()*5))

In B2 10
In B2 15

If this post helps click Yes

 

[tcidawn]

Your formula worked for your example as you stated. However, it is not the
result I am looking for.

When I can state my needs more clearly, I will repost.

Thanks,
Dawn

 

[tcidawn]

Jacob,

OK It is after lunch now and I have a clearer head. The formula IS what I
want, I just need the part it references the other workbook.

Thanks for your help and sorry for my confusion.

Dawn

 

[Jacob Skaria]

Great. That lunch would have certainly made a difference..

If this post helps click Yes

 

[tcidawn]

Jacob,

Where would your formula be placed in the information below?

='[2008 MM, Debit, Interest.xls]2009'!AU31

Thanks,
Dawn

 

[Jacob Skaria]

Try the below (all in one line)

=SUM(INDIRECT("'[2008 MM, Debit,
Interest.xls]2009'!A"&(ROW()-1)*5+1&":A"&ROW()*5))

If this post helps click Yes
---------------
Jacob Skaria

Jacob,

Where would your formula be placed in the information below?

='[2008 MM, Debit, Interest.xls]2009'!AU31

Thanks,
Dawn

Great. That lunch would have certainly made a difference..

If this post helps click Yes