Lookup And Sum Multiple Columns

    I have a daily report of product shipped and multiple product codes.
    These codes are then put into product groups.


    Example
    Product Group Wire Spares Wire Spares Equipment
    Product code 3910 3911 3912 3913 3914
    Sales by Day
    Day 1 10 15 20 5 300
    Day 2 5 10 35 50 200
    Day 3 20 35 20 0 250


    How can I use a function to group and sum to the produce this output
    Sales by Day Wire Spares Equipment
    Day 1 30 20 300
    Day 2 40 60 200
    Day 3 40 35 250


    See attached file


    Thanks

    Re: Lookup And Sum Multiple Columns


    Could you give more details.
    In the file sent in line 1/00 in the Input Section total is 501500.05 as in the Output Section but items ( Spares, Hi, Powder etc...) are not the sames.
    The Total of Spares in Input is 47152 and 53427.6 in Output.
    How would like to sum data?

    Triumph without peril brings no glory: Just try

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login