From: FredZack on
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.
From: Dave Peterson on
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