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

=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?

Hi

Try
=SUM(Sheet1:Sheet20!A1)
Change the value of sheet20 to the highest sheet number in your book.
Be aware however, that if the sheets are not in sequence, you may not
pick up the correct answer.

I prefer to create 2 new sheets called First and Last and drag these to
encompass the range of sheets I am interested in.
The
=SUM(First:Last!A1)
will total all A1 cells within the "sandwich".

--
Regards

Roger Govier


"mo_tussin" wrote in message
...
HOW DO I ADD A SPECIFIC CELL IN ALL SHEETS OF A WORKBOOK?

=SUM(Sheet1:Sheet3!A1)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"mo_tussin" wrote in message
...
HOW DO I ADD A SPECIFIC CELL IN ALL SHEETS OF A WORKBOOK?

What does "add a specific cell" mean? What do you want to do? HTH Otto
"mo_tussin" wrote in message
...
HOW DO I ADD A SPECIFIC CELL IN ALL SHEETS OF A WORKBOOK?