Sum + Indirect using Dynamic Range

[gradyshock]

Hello All,


I am having trouble with the following formula. I need a way to make the starting cell P25 a dynamic reference.
=SUM(INDIRECT("$P$25:$P" & ROW()-2))


Every time the user double clicks the add row macro P25 increments by 1 P26 ect.


I've attached a link to the sheet...

ftp://WSUser:WSUser!!@mail.westernsierras.com/Revised_Quote_sheet_03.26.14.xlsm

 

[hippiehacker]

and why not use a named range?

 

[gradyshock]

and why not use a named range?

I'm open to suggestions... Can you use a named range when the macro adds rows? Everytime the click to add rows button is used the first cell changes.

How would you solve this?

 

[hippiehacker]

the named range should always start from P25?

 

[gradyshock]

P25 is the start unless a row or more is added then it could be p26, p27, ect.. depending on how many rows the user adds