Hi,
I have several suppliers and each has a few commodities.
A sample you can see in table A.
Table A
Date Supplier Commodity Sum $
1.4.2011 A Fish 1,251
2.4.2011 A Meat 8,247
12.4.2011 B Veg 1,020
3.4.2011 C Comfit 258
8.4.2011 B Veg 547
5.4.2011 A Fish 891
20.4.2011 A Fish 953
9.4.2011 B Fruits 745
Total 13,912
What I want is to get a summery table that sum the amount of purchase from each supplier divided to the commodity type. You can see it in table B.
Table B
Supplier
A Fish 3,095
A Meat 8,247
B Veg 1,567
B Fruits 745
C Comfit 258
Total 13,912
I hope I and the data are clear.
Using windows xp Excel 2003.
Thanks,
Amnon
Bookmarks