copy formula

[melle]

I got a problem with inserting formulas:

For example:

I want to get the following formulas in de following cells:


B1: Sum(B1:B10)
B2: Sum(B11:B20)
B3: Sum(B21:B30)
B4
etc.
etc.

If I copy the cells down the next formula is plus 1. So the formula i
B4 is then
Sum(B22:B31) in stead of sumB31:B40.

How can I solve the problem. Manauly is too much work as the databas
contains thousends of rows.

I hope someone can help me.

Regards,

Mell

 

[Bernie Deitrick]

Melle,

In cell C1, use the formula (in column B that would result in a circular reference):

=SUM(INDIRECT("B"&10*(ROW()-1) +1 & ":B" & 10*ROW()))

and copy down for 1/10 of the number of rwos of column B.