Why not use the Subtotals feature?
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
VBA Project Manager
www.OfficeArticles.com

"Rhiannon" wrote in message
...
I have spreadsheet with various subtotals. I need a grand total at the end,
how do I sum a range of subtotal?