View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
FredZack FredZack is offline
external usenet poster
 
Posts: 7
Default 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.