+ Reply to Thread
Results 1 to 6 of 6

Cell Refrencing multiple sheet totals to a totals page

  1. #1
    Registered User
    Join Date
    12-03-2015
    Location
    sidney, ne
    MS-Off Ver
    Office 2013
    Posts
    29

    Cell Refrencing multiple sheet totals to a totals page

    So I have a monthly spreadsheet for every month and then a totals sheet to show an annual count, but it does have a month by month breakdown. On every monthly spreadsheet I have a totals cell that is the same for every month, but I have 28 different things that I am tracking that has a total. So for instance in my totals page in cell c3 it will read =January!C$53 cell c4 will read =February!C$53 cell c5 will read =March!C$53, so on and so on. Is there anyway for me to just put in the January cell total, and then drag down so it pulls cell C53 from every months page, so I don't have to click on every months tab and click on cell C53?

    Sorry if this is confusing. Let me know if you have questions or if I need to post any spreadsheets to clarify. Thank you for your help this would save me a lot of time clicking through all of the sheets.

    Thanks again!

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,192

    Re: Cell Refrencing multiple sheet totals to a totals page

    Please post a spreadsheet showing some expected results.

  3. #3
    Registered User
    Join Date
    12-03-2015
    Location
    sidney, ne
    MS-Off Ver
    Office 2013
    Posts
    29

    Re: Cell Refrencing multiple sheet totals to a totals page

    If you go to the 2016 totals tab click on cell b7 you will see it =January!C$57 cell b8 should equal the same cell just with February instead =February!C$57, so I need to keep C$57 because that is the same for every month, I was just wondering if I could drag down from January to December so I don't have to manually go through every single month back and forth from tab to tab.

    Hope this helps. Thanks for your help.
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,192

    Re: Cell Refrencing multiple sheet totals to a totals page

    Try

    =INDIRECT("'" &$A7 &"'!C$57") and copy down

    Change 57 to 58 etc

    Repeat for Data in Column J onwards
    Last edited by JohnTopley; 12-08-2015 at 02:13 PM.

  5. #5
    Registered User
    Join Date
    12-03-2015
    Location
    sidney, ne
    MS-Off Ver
    Office 2013
    Posts
    29

    Re: Cell Refrencing multiple sheet totals to a totals page

    That worked. Thanks a lot John!

  6. #6
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,192

    Re: Cell Refrencing multiple sheet totals to a totals page

    Thank for the feedback.

    If problem is solved can you mark thread as such ("Thread Tools" at top of first post).

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Help populating a cell formula (totals) on new tabs to infinity on a final page
    By cheeseburgers in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-21-2014, 03:32 PM
  2. [SOLVED] running totals in Pivot Table - removing a user from the totals for the current week
    By eisenbergg in forum Excel Charting & Pivots
    Replies: 12
    Last Post: 09-08-2013, 04:39 PM
  3. [SOLVED] Sum workday totals on one sheet to weekly totals on another
    By BryanD in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-26-2013, 10:08 AM
  4. [SOLVED] How do I group daily totals into weekly/monthly/quarterly totals
    By situationroom in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-28-2013, 09:58 AM
  5. Totals from worksheets on a totals sheet
    By tongy66086 in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 05-17-2008, 09:50 PM
  6. Replies: 4
    Last Post: 01-10-2008, 12:31 PM
  7. Replies: 1
    Last Post: 01-17-2007, 10:49 PM

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