View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Kevin Stecyk Kevin Stecyk is offline
external usenet poster
 
Posts: 74
Default Summation of rows

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


"Mike" wrote in message
...
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.