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.
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.
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
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By SimpleJack in forum Excel Formulas & Functions
Last Post: 07-19-2013, 08:54 AM
By JJMC1981 in forum Excel Formulas & Functions
Last Post: 05-17-2013, 12:11 PM
By excelguru(not) in forum Excel General
Last Post: 04-27-2011, 11:03 PM
By LaZyNala in forum Excel Programming / VBA / Macros
Last Post: 10-11-2010, 02:46 PM
By RockyFTI in forum Excel General
Last Post: 06-15-2009, 12:08 PM
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1