For relatively small columns (a few thousand figures) I would frequently just use a quick and dirty inline fixed maximum length figure such as SUM(A:A 1:10000), problem solved. For an advanced approach requiring performance optimization and clarity I'd use named ranges or tables. While named...