Help

[Guest]

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

 

[Guest]

=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

 

[Roger Govier]

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".

 

[Bob Phillips]

=SUM(Sheet1:Sheet3!A1)

--

HTH

Bob Phillips

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

 

[Otto Moehrbach]

What does "add a specific cell" mean? What do you want to do? HTH Otto