Assuming that Column A contains your list and the first row contains
your label, try...

=SUM(A2:INDEX(A:A,MATCH(9.9999999999999E+307,A:A)) )

Hope this helps!

In article ,
"Peter" wrote:

I want to add a total to lists of variable lengths when I don't know how long
the list will be. I want to do this by formula and not using the subtotal
function. Any ideas? Thanks.