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


"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"tcidawn" wrote:

Jacob,

My results were 0 with the formula as stated.

Dawn

"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"tcidawn" wrote:

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)