A 1
B 2
C 3
D 4
E 5

Day 1 A C A E D 14
Day 2 E D C E D 21
Day 3 C B A B D 12

I have a table that contains 100 codes (a,b,c,d,etc) and 100 values (1,2,3,4,etc)
For Day !, I want to count all of the A's, multiply by 1, count all of the B's multiply by 2, all of the C's, multiply by 3, etc and then get a final answer. In this small example, the answers are 14, 21, 12