M
mo_tussin
HOW DO I ADD A SPECIFIC CELL IN ALL SHEETS OF A WORKBOOK?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
bpeltzer
=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
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
R
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".
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".
B
Bob Phillips
=SUM(Sheet1:Sheet3!A1)
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
O
Otto Moehrbach
What does "add a specific cell" mean? What do you want to do? HTH Otto