SUm function and adding rows
 

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.

SUm function and adding rows
 

You could use a formula like this in C23:

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



FredZack wrote:

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