+ Reply to Thread
Results 1 to 3 of 3

Summing between worksheets

  1. #1
    Forum Contributor
    Join Date
    07-20-2015
    Location
    Jacksonville, Florida
    MS-Off Ver
    Excel 2016
    Posts
    303

    Summing between worksheets

    I have worksheets with a column of names and a column of totals. Each worksheet represents a month. The names have been deleted/added from one month to the next. I need to add the totals for each name over 6 months. Is that do-able when the names are in different cells.

    Example:

    A name in cell A15 in the October worksheet may be in cell A10 in the November worksheet or may have been deleted from the January worksheet.

    I need to accumulate totals for each person across the six month period. I am attempting to attach my workbook. ** I just go new desktop - old one used Windows XP and new one is Windows 10. When I go to manage attachments I select Browse files and I do an open on the file, then I select the 'UPLOAD" button and it appears on the screen under the "Attached Documents" section, but there is not "Done" button and I don't see the attachment on the post.

    In the event it is not attached:

    Column A contains the names and Column N contains the totals I want to accumulate for each name.

    Thanks in advance for any help.
    Attached Files Attached Files

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,359

    Re: Summing between worksheets

    i suggest indirect and such structure
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    07-20-2015
    Location
    Jacksonville, Florida
    MS-Off Ver
    Excel 2016
    Posts
    303

    Re: Summing between worksheets

    Thanks for the reply Tim.

    I will attempt to apply it - I'm not familiar with the Indirect command - Can you tell me what part of the INDIRECT command in your sample points to worksheet named "1015" as I will need to point to the worksheets in my workbook.

    Thanks again - looks like the correct solution

+ 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. Summing mulitple worksheets
    By Journeyman3000 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-18-2014, 04:55 PM
  2. [SOLVED] Summing across many worksheets
    By John Blissett in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 09-13-2013, 02:12 AM
  3. Summing across multiple worksheets
    By AberdeenGDK in forum Excel General
    Replies: 9
    Last Post: 02-20-2012, 03:14 PM
  4. Excel 2007 : Summing totals on different worksheets
    By Chainsaw_019 in forum Excel General
    Replies: 6
    Last Post: 08-21-2011, 01:06 AM
  5. Summing across worksheets
    By JJanssen in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-30-2008, 06:04 PM
  6. [SOLVED] Summing across several worksheets
    By Al in forum Excel General
    Replies: 5
    Last Post: 03-16-2006, 09:10 AM
  7. [SOLVED] Help finding and summing across worksheets
    By Joe Tapestry in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-15-2006, 06:40 PM
  8. summing multiple worksheets
    By Kamie in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-03-2006, 02:20 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