how do I sum the same cell from multiple worksheets? In this case I will have
about 125 worksheets in the workbook so I'm looking for a shortcut. Thanks
how do I sum the same cell from multiple worksheets? In this case I will have
about 125 worksheets in the workbook so I'm looking for a shortcut. Thanks
Hi!
The easiest way if you use the default sheet names Sheet1,
Sheet2 .... Sheet125
=SUM(Sheet1:Sheet125!A1)
If you use custom sheet names:
Insert a new sheet before the first sheet and name it
START. Insert another new sheet after the last sheet and
name it END.
=SUM(Start:End!A1)
If you will need to create any new sheets that should also
be used in this calculation just insert them between START
and END.
Biff
>-----Original Message-----
>how do I sum the same cell from multiple worksheets? In
this case I will have
>about 125 worksheets in the workbook so I'm looking for a
shortcut. Thanks
>.
>
=SUM(sheet1:sheet125!A1)
If sheets have unique names...........
Add a new dummy sheet after the Summary sheet which I assume is first in book.
Name this sheet Start.
Add a new dummy sheet at end of book and name it End
On Summary sheet =SUM(Start:End!A1)
Any new sheets will inserted between Start and End
Gord Dibben Excel MVP
On Thu, 17 Feb 2005 21:09:02 -0800, "rbperrie"
<[email protected]> wrote:
>how do I sum the same cell from multiple worksheets? In this case I will have
>about 125 worksheets in the workbook so I'm looking for a shortcut. Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks