Sum + Indirect using Dynamic Range

[shocks24]

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 the sheet...

[jaslake]

Hi shocks24

See if this helps...replace that Formula with

Please Login or Register  to view this content.