dynamically calculated row number

K

keith0628

In my worksheet, I have nine rows that have formulas that refer to
value in the tenth row. I would normally make that cell referenc
absolute, however, I need to copy the formulas from those ten rows ove
several hundred rows. I'd rather not have to edit the absolut
reference over and over again. Is there any way to do dynamicall
calculate the row number for a cell reference?

For example, here's the formula in cell B10 (($D$3*$A10) + $A$19) an
the formula in cell B11 (($D$3*$A11) + $A$19) and so on. But if I cop
the formulas from B10 - B19 to B20 - B29, I want the fixed reference t
be A29. How can I do this
 
J

Jason Morin

Try this in B10 and copy down:

=(($D$3*$A10)+INDIRECT("A"&FLOOR(ROW(),10)+9))

HTH
Jason
Atlanta, GA
 
Top