| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add numbers belonging to a vendor
Dear Excel(lent) users,
I have a simple problem, which I tried with sumif, but does not seem to work. I hav a list of purchase orders. Each purchase order consists of the po number, the amount, the article and the vendor. Now I want to know how much we have spent per vendor. SHEET 1 -------------------------- Column A: Po number Column B: Amount Column C: Article Column D: Vendor name On a different sheet I have the names of the individual vendors: SHEET 2 ---------------------------- Column A: Vendor name Column B: Calculation of all PO's Amounts added up per vendor name in A Can you help me please? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a Vendor ID from Vendor Name... | Excel Worksheet Functions | |||
| How do I set up a way to keep track of vendor invoices? | Excel Worksheet Functions | |||
| How do I get excel to shade grey at every different vendor name? | Excel Discussion (Misc queries) | |||
| INSERT LINE after Vendor name change | Excel Worksheet Functions | |||
| How do you create a vendor tracking form for accounts payable pro. | Excel Discussion (Misc queries) | |||
Threaded Mode
