Summation of rows

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Hi. I have a list of numbers in C26 through C36. Cell
C37 sums these. I need for the user to be able to add
rows and have the summation cell change accordingly.
This works unless the user inserts a row after the last
row.

Is there a way, through programming or otherwise, to make
the formula change even in this situation? I do have a
variable in my macro called "lastRow" that records the
row number of the summation row (currently 37).

Thanks,
Mike.
 
Hi Mike,

I think the following formula entered on C37 should help you.

=SUM($C$26:OFFSET(C26,-1,0))

I had seen this type of an formula used to a very similar question to your
recently. I thought it was a good solution. Hopefully, it works for you
too.

Regards,
Kevin
 
Back
Top