=SUM(Sheet1:Sheet3!A1) will add the contents of A1 on all worksheets from
Sheet1 through Sheet3. I often add 'dummy' sheets before and after those
whose contents I wish to add so my '3d-sum' looks like
=sum(StartSheet:EndSheet!A1)
--Bruce

"mo_tussin" wrote:

HOW DO I ADD A SPECIFIC CELL IN ALL SHEETS OF A WORKBOOK?