Copy/Fill increments

T

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)
 
J

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
 
J

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
 
T

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
 
T

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
 
J

Jacob Skaria

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

If this post helps click Yes
 
T

tcidawn

Jacob,

Where would your formula be placed in the information below?

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

Thanks,
Dawn
 
J

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


tcidawn said:
Jacob,

Where would your formula be placed in the information below?

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

Thanks,
Dawn

Jacob Skaria said:
Great. That lunch would have certainly made a difference..

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top