Hi, Peter. Same Peter? :)
What I usually do in this case is put my headings in Row 2 and my totals in
Row 1, where the formula in Row 1 might be something like =Sum(A3:A65536).
************
Anne Troy
www.OfficeArticles.com

"Peter" wrote in message
...
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.
--
Peter
London, UK