Use ROW() within =SUM ?

[lbdyck]

I have a worksheet with a column of numbers (column F) and in column G I want to have a running total.

This works =sum($f$4:f8) but if a row is inserted then this fails. I've tried to use =sum($f$f:row()) but it doesn't work - invalid.

Any pointers?

thanks

[AliGW]

If a row is inserted where? Why can't you insert rows at the bottom and then sort? If you are using a properly structured Excel table, you'll be able to do this.

[Pete_UK]

Try it like this:

=SUM(INDIRECT("F1:F"&ROW()))

then copy down. Alternatively, you could do this:

=SUM($F$4:$F8)

if the formula is on row 8, and then copy down.

Hope this helps.

Pete

[lbdyck]

Pete's answer was the solution - THANK YOU

[lbdyck]

Thank you but the issue is that inserts break the rows below.

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.