Problem: How to sum a column with values automatically, when a new row is inserted ?

Solution: Type =SUM(B1:OFFSET(B7,-1,1)) in cell B7.

OFFSET makes this summation automatic even when a new value is inserted.

OFFSET(reference;rows;cols;[height];[width])
Returns a reference to a range taht is a given number of rows and columns from a given reference

SUM(number1;[number2];