+ Reply to Thread
Results 1 to 7 of 7

Adding values from sheets to sheet

  1. #1
    Registered User
    Join Date
    02-28-2007
    Posts
    3

    Adding values from sheets to sheet

    Hey!

    Did some searching and didn't come up with anything so I'm posting. Ok here's the deal..

    Working on my company timesheet using excel and it works great. However I would like to add a value from multiple sheet without having to select or type them in for each sheet (there's about 50 of them). It's the same cell in each sheet I want to add up for a total. I tried to do it manually but excel kept asking to open something but not sure what and it wouldn't let me do more then 3. Any help would be appriciated.

    Thanks!

    --
    Rick

  2. #2
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi,

    To add cell A1 from sheet1 to sheet50 ...

    Please Login or Register  to view this content.
    HTH
    Carim


    Top Excel Links

  3. #3
    Registered User
    Join Date
    02-28-2007
    Posts
    3
    Quote Originally Posted by Carim
    Hi,

    To add cell A1 from sheet1 to sheet50 ...

    Please Login or Register  to view this content.
    Ok having some problems. Here is what I'm trying to use..

    =SUM('Jan 2':'Dec 25'!A43)

    All the sheets are labeled "Jan 2", "Jan 9"... all the way through "Dec 25" (every Tuesday for this year). If I've changed the name of the sheet do I need to put ' around the name if there are spaces? I keep getting errors saying the formula does't work.

    Thanks!

    --
    Rick

  4. #4
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi,

    Have a try with following formula ...

    Please Login or Register  to view this content.

  5. #5
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Glad it fixed your problem ...

  6. #6
    Registered User
    Join Date
    02-28-2007
    Posts
    3
    Thank you! That did the trick. I had to many ' in there.

  7. #7
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Thanks for the feedback ...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1