Auto Sum each Row in one Column

If it is ChemistB's solution you say works, then you can also employ the List feature found in the Data menu.

It allows you to insert new rows, and automatically have formulas copy down to those new rows.