Hi! I'm bumping this because I have the same question. I found the following post which works except when the total line is added, it clears out my formulas.

http://www.excelforum.com/showthread...floating+total

I was also considering having a "Total" line say around row 300 and maybe hiding the blank rows. But I can't figure out how to keep that Total row visible (or have it float down) while allowing the user to add more rows.

I would really appreciate some advice on how to handle this...

Thanks,
Michele