+ Reply to Thread
Results 1 to 2 of 2

Formula needed to sum multiple match criteria

  1. #1
    Registered User
    Join Date
    South Yorks, England
    MS-Off Ver
    Excel 2010

    Formula needed to sum multiple match criteria

    I am needing a formula to sum info from 1 book to another based on two lookup criteria. Its the sort of info you can easily get with pivot tables or filters but my colleague needs a copy and pastable formula so it can be automated.

    There are two workbooks Order Index example.xlsxCash Flow book example.xlsx; one called "Order Index" has a list of orders placed along with supplier name (Col C), date due for payment (Col H) and value of order (Col I). The other workbook, used by a colleague is called "Cash Flow" and contains a list of supplier names (Col B) with row 1 containing months (1st Jan 2014, 1st Feb 2014 etc).

    Under each month on the "Cash Flow", I need to show the sum of orders due for payment within that month, for each supplier named (in Col B). In other words, sum the figures from the "Order Index" based on supplier name and date due for payment.

    Often, on the Order Index there is more than one order per month from a supplier and the dates due are specific days (10th Jan, 21st Jan etc) and these need summing up for the 1st Jan 2014 Column in the Cash Flow book.

    Can you help?
    Last edited by bensox; 02-05-2014 at 08:52 AM. Reason: Bump! Any advice? Maybe I should reword my question.

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    MS-Off Ver
    2003 To 2010

    Re: Formula needed to sum multiple match criteria

    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved

    If the suggestion helps you, then Click *below to Add Reputation

+ 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. Excel 2007 : Index, Match, Large Formula: Multiple Criteria, Multiple Ranges
    By SimpleJack in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-19-2013, 08:54 AM
  2. Multiple Criteria formula - HELP DESPERATELY NEEDED!
    By JJMC1981 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-17-2013, 12:11 PM
  3. Multiple Criteria Formula Needed
    By excelguru(not) in forum Excel General
    Replies: 1
    Last Post: 04-27-2011, 11:03 PM
  4. Multiple criteria formula needed
    By LaZyNala in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-11-2010, 02:46 PM
  5. Replies: 3
    Last Post: 06-15-2009, 12:08 PM

Tags for this Thread


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