sum up a dynamic-changed list of numbers

minrufeng · Feb 22, 2006

for example:

A1: 10
A2:5
A3:4
A4:11
A5:1
A6:sum(A1:A5)

A8:not empty
A9:not empty

Flintstone · Feb 22, 2006

Try this

=SUM(INDIRECT("A1:A"&ROW()))

Matt