Hi,
I am trying to create a workbook that allows me to to trace costs against various Purchase Orders. So, for example, I'll have a sheet with the list of PO's, a sheet with the list of invoices against PO's, and a sheet with a list of expenses incurred which are always assigned to a PO.
The invoice and expense sheets will have multiple line entries that will include many PO's, but, critically, there may be more than more entry assigned to each PO.
I am trying to produce a summary sheet that extracts the values against each.
Example - Cost sheet may have 100 lines in, of which 10 are allocated to a single PO number which appears on the PO sheet. Each of these 10 lines contain another field which is net value. How can I extract the sum of the net values for the single PO which appears in 10 entries?
VLOOKUP would obviously find the single occurence, so how do I find multiple occurences and then add together the values that appear in a different column for those?
Hope that makes sense!!
Vince
I am trying to create a workbook that allows me to to trace costs against various Purchase Orders. So, for example, I'll have a sheet with the list of PO's, a sheet with the list of invoices against PO's, and a sheet with a list of expenses incurred which are always assigned to a PO.
The invoice and expense sheets will have multiple line entries that will include many PO's, but, critically, there may be more than more entry assigned to each PO.
I am trying to produce a summary sheet that extracts the values against each.
Example - Cost sheet may have 100 lines in, of which 10 are allocated to a single PO number which appears on the PO sheet. Each of these 10 lines contain another field which is net value. How can I extract the sum of the net values for the single PO which appears in 10 entries?
VLOOKUP would obviously find the single occurence, so how do I find multiple occurences and then add together the values that appear in a different column for those?
Hope that makes sense!!
Vince
