SUm function and adding rows
in [General]
|
From: FredZack on 22 Mar 2010 15:22 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 22 Mar 2010 16:10 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
|
Pages: 1 Prev: Issues - ghost data Next: Remove a document from a workspace in Excel 2007 |