Add numbers belonging to a vendor

[Guest]

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

 

[Guest]

Hi,

Try this on sheet 2 column B

=SUMPRODUCT((Sheet1!D2100=A2)*(Sheet1!B2:B100))

Where sheet2 A2 is a vendor name that appears in column D on sheet 1

Mike

 

[Guest]

To throw a spanner in the works, maybe you should try designing a database.

 

[Tyro]

A database, as in an Access database, to answer a simple question as the one
posed??
Please try to contribute, and not act silly

Tyro

 

[Peo Sjoblom]

A pivot table is perfect for this. select the data in sheet 1, do data>pivot
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