A pivot table is perfect for this. select the data in sheet 1, do datapivot
table and pivot chart report, click next twice, select layout and drag the
vendor name header to the row and the amount header to data, click OK and
click Finish.
That will add a new sheet with the data per your request


--

Regards,

Peo Sjoblom




"The Fool on the Hill" wrote in
message ...
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?