Article updated on September 04, 2007

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.

Returns a reference to a range taht is a given number of rows and columns from a given reference