Thank you for patiently waiting. It really took me a lot of time to come up with what you really wanted or desired. I believe I was able to come up with the complete solution and here is the summary:
- You have 2 Excel files: PO List and Projections.
- In your PO list file, you need to determine entries that are DUE or NOT YET DUE.
- When an entry is DUE, you want to collect ALL DUE entries in the entire month and then SUM UP the PO Total values in column L.
- Place the SUM of the PO Totals in their corresponding months in Projections.xlsx file.
In order to accomplish this, I need to create a NEW sheet that will perform #2 above. I called the sheet Overdue_Status.
The purpose if this sheet is critical. It will convert the due date into months and it will test the entries if it is Overdue or Not Due. Also, I copied the PO Total values in Column L in this sheet.
Then, in order to push the SUM of all Overdue items, the formula will now test the conditions in the Overdue_Status sheet. The appropriate formula is SUMIFS(). In this case, You sum the PO Total column IF:
- The month shown in the Due Month column is equal to the month header. That is, for the April column (Projections sheet or file), Due Month must be April.
- The Status must be Overdue in the Status column.
In this case, only Overdue entries for the month of April will be totalled under April. The same logic applies in the other months.
Also, I added Projections sheet as a testing before I worked on the separate Projections file.
Here are the download links:
http://wikisend.com/download/752012/Purchase Orders List 2013-4_jess.xlsx
NOTE: Since the Projections file is dependent on the PO List file, the 2 files must be saved in the SAME folder. Also, you can see the Projections sheet the results of the formulas that I made for you.
Please remember to rate my service positively (3-5 stars/faces) if this helped. Tips are always highly appreciated!
If you have any other questions, please ask me or reply to me – I’ll be happy to respond.