Total qauntity for unique tags

  • Total qauntity for unique tags 0

    1. Please help with this task (0) 0%
    2. Need your help with array formula in excel/VBA (0) 0%

    I have A long excel file that looks like this (Please see below)


    A B C D E
    1 ITEM 11141 11219 44312 12100
    2 TAG 5555 1111 8888 6666
    3 QTY 200 200 200 200
    4 TAG 4444 3333 9999 6666
    5 QTY 100 100 100 100
    6 TAG 5555 1111 9999 7777
    7 QTY 100 100 100 100
    8 TAG 4444 3333 8888 6666
    9 QTY 100 100 100 100
    10 TAG 4444 1111 8888 7777
    11 QTY 200 200 200 200




    Now, My question is that I want a total qty for each unique tag number for that Item.

    for example1. Item : 11141(B1) Tag # 5555 Total Qty : 300 ( B3 + B7), Item # 11141B1) Tag # 4444 Total Qty : 400 (B5+B9+B11)
    for example2. Item : 11219(C1) Tag # 1111 Total Qty : 500 ( C3 + C7 + C11)

    I am not sure If it is doable or not.


    Thanks for your help