Article updated on November 05, 2007

How to sum an increasing column:

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

Counts the number of cells in a range that are not empty