+ Reply to Thread
Results 1 to 2 of 2

Help summing values across multiple sheets with criteria

  1. #1
    Registered User
    Join Date
    06-09-2016
    Location
    Saskatchewan, Canada
    MS-Off Ver
    2010
    Posts
    1

    Help summing values across multiple sheets with criteria

    Hello folks,

    I have a problem that has been plaguing me for far too long. Basically I have 6 worksheets in my book. 5 are titled "DEC" "JAN" "FEB" "MAR" "APR" and the last one is just "Sheet2". On the month sheets I have a list of about 120 numbers each 7 characters long. On Sheet 2 I have another list of the same type of numbers and also an amount beside them. What I am trying to do is compare the numbers in Sheet2 to the month sheets and if they match take the value beside it and sum it with all other matching values. However, some of the numbers in Sheet2 appear in more than 1 of the month sheets, so I need to avoid double counting. I can get the desired result with a VLOOKUP and then summing the values by hand, but this is extremely tedious and not at all future proof. I know there must be some combination of SUMPRODUCT/SUMIF statements that I can use to get what I am looking for. Thank you for taking the time to read my problem and helping!

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Help summing values across multiple sheets with criteria

    Can you post a sample workbook representative of your data and your proposed solution?
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a 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. [SOLVED] Two criteria Index Match on multiple sheets returning multiple values
    By Joak in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-21-2014, 10:03 AM
  2. Replies: 12
    Last Post: 02-10-2014, 11:59 AM
  3. [SOLVED] Lookup and sum multiple values based on a single criteria in multiple sheets.
    By paulsanett in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-17-2014, 12:18 PM
  4. Summing of Multiple Criteria sum but not counting Duplicate Values
    By chadman in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-25-2013, 07:34 AM
  5. Summing values in named ranges based on dates, multiple sheets!
    By giggsteve8 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-02-2013, 01:42 PM
  6. Summing Values in column based upon multiple criteria
    By shantanuk in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-21-2012, 09:29 AM
  7. Replies: 8
    Last Post: 07-13-2012, 06:00 AM
  8. Summing Values accross multiple sheets
    By randell.graybill in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-01-2009, 05:17 AM

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