Total qauntity for unique tags

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