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 