Provided you've got the totals in the same cells in each worksheet, you can
use this method:
http://www.officearticles.com/excel/...rk sheets.htm
************
Anne Troy
www.OfficeArticles.com

"MCV Celebration, FL" <MCV Celebration, wrote
in message ...
I am trying to total data elements from weekly worksheets to a final work
sheet which will give me quarterly and semiannual totals.