SUm function and adding rows

[FredZack]

Is there a way to get the SUM function to increase the range if a row is
added right above the previous SUM range. FOr example to go from SUM(C3, C22)
to SUM (C3, C23) when I insert a row directly above row 24 - wher the SUM
function resides.

 

[Dave Peterson]

You could use a formula like this in C23:

=SUM(C2:OFFSET(C23,-1,0))

 

[Lynz]

You could use a formula like this in C23:

=SUM(C2:OFFSET(C23,-1,0))

If you sum a named range then the inserted row will be included in your
sum and the rangr will expand to suit. ?? Works ok for me.