SUm function and adding rows

  • Thread starter Thread starter FredZack
  • Start date Start date
F

FredZack

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.
 
You could use a formula like this in C23:

=SUM(C2:OFFSET(C23,-1,0))
Click to expand...
If you sum a named range then the inserted row will be included in your
sum and the rangr will expand to suit. ?? Works ok for me.
 
Back
Top