Are the formulas in consecutive rows? If so then us the ROW() function to
supply the denominators.

For example, starting in Row 10 if the formula is the sum od A10, B10 & C10
divided by 3 then

=SUM(A10:C10)/(ROW()-ROW($A$7))

will provide the answer and it will index the denominator as it is dragged
down the column.

(ROW()-7) would work just as well but it will go wrong if a row in inserted
or deleted.

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"V" wrote in message
...
I need to create an excel spreadsheet using a math equation that has one
variable that is the denominator of a fraction. I need to be able to
change
the variable every row. Ie - starting variable is 3 and last variable is
101. Any tips would be greatly appreciated!! Thank you