Results 1 to 2 of 2

Sum Suppliers Activity

Threaded View

  1. #1
    Registered User
    Join Date
    03-28-2011
    Location
    Rehovot, Israel
    MS-Off Ver
    Excel 2003
    Posts
    2

    Sum Suppliers Activity

    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
    Last edited by wilensky; 03-28-2011 at 08:25 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1