How to sum an increasing column:

SUM(number1,[number2],)
Adds all the numbers in a range of cells

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

COUNTA(value1,[value2],)
Counts the number of cells in a range that are not empty