Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Sum Work sheets in a work book

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    Surfers Paradise
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I sure Ive done this before.
    I have a work book with 55 worksheets in it and want to sum a the same cell in each sheet. I have tried =sum(sheet(1)!a1:'sheet(55)'!a1) when I point to the cells this is what it comes up with as well but it won't work

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,024
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    7 Thread(s)

    Default

    On 2002-05-12 17:53, Lewy2 wrote:
    I sure Ive done this before.
    I have a work book with 55 worksheets in it and want to sum a the same cell in each sheet. I have tried =sum(sheet(1)!a1:'sheet(55)'!a1) when I point to the cells this is what it comes up with as well but it won't work
    =SUM(Sheet1:Sheet55!A1)

  3. #3
    New Member
    Join Date
    May 2002
    Location
    Essex
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Type =SUM( in the cell where the answer is to appear.
    Click on the tab of the first sheet to be summed and select the cell to be summed.
    Hold down the SHIFT key and click on the tab of the last sheet to be included.
    Type ) to close the SUM.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •