dynamically calculated row number

  • Thread starter Thread starter keith0628
  • Start date Start date
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
 
Try this in B10 and copy down:

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

HTH
Jason
Atlanta, GA
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HLOOKUP - Relative cell reference in row index number 0
Formula Cell color limitation 7
Using =IF(B10<>"",COUNTA($B$10:B10),"") to number rows in columns other than A 2
Copy Conditional Formatting down rows 5
Data validation- absolute ref or not- neither works 3
sum of rolling (set number cells above the total)l 4
How can my formula handle inserted rows? 3
Copy and Paste Conditional Formatting 3

Back
Top