Dominic: I'd like to add that to my articles. Can you describe it? I'd LOVE
that. :)
************
Anne Troy
www.OfficeArticles.com

"Domenic" wrote in message
...
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.