Vivian Wrote:
However, whenever I insert rows in between the data and
the row that contains the total sum, I need to manually adjust the
summation
formula.(eg. formula above + G15+G18+G21).

This doesn't seem right. Excel by default caters for rows being added.
Can you explain the exact sequence of events, or post a sample
spreadsheet


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=563520