excel formula adding problem

[foz1002]

Hi please can you guys help me im stuck with a a formula which is

=SUM(J12/1)/100

i want to copy the formula downwards and would like the number 1 to increase by 1 everytime

for example

SUM(J12/1)/100
SUM(J13/2)/100
SUM(J14/3)/100
SUM(J15/4)/100

is there any way possible in getting this formula to work as I have 200 cells

thanks

 

[shobolos]

Replace the 1 with -

=ROWS(A$1:A1)

- and copy it down

 

[djrod1rep]

If your data starts in Cell A1, then you can use this to increase the denominator:

Cell A1: =SUM(J12/ROW())/100

Copy this formula down to the necessary rows of data.

If your data starts in another row, what row would it start on normally?