Referencing a cell where the row number will change

[davidanaya11579]

Back for more help Geniuses!! I am working on a form where the user has multiple options for adding additional lines via command buttons. The adding of additional rows of information is all but guaranteed. Further down the form I need to sum 3 separate cells for a grand total, but the row numbers of the three cells I need to sum will change with the addition of additional rows of data.

EX: on the blank form the data that needs summed is located at O25, O29, and O33, however, when the user adds more lines to the form to fit the additional lines of data, those row numbers will all move by 1 row. Many additional rows of data would offset those numbers even more.

Is there anyway to write a formula that will trace those original cells as additional rows are added?

 

[davidanaya11579]

Desperate for some help folks!

 

[TimNevins]

If you are inserting rows (which is what it sounds like) the formulas will update themselves and remain accurate. As a test put values in a2 through a4. Create a sum formula in a8 to sum up a2:a4. Select row 1, right click and select Insert. Your formulas should still point to the original cells. If you insert rows between the existing values the formula will be correct.

Not sure if there is something more at play with your question.