and I appologize if this is a no brainer, but I cannot find an answer on the net.

I want to assign a letter to an object and then enter that letter and a number in 1 cell and have a total show in another cell.

For instance

A = apple
B = Brocolli
C= cod
D= dates

in a cell (one cell - not individual cells) I would record A23,C44,D11
and the next cell dow A21,B33,C18,D55
and so on

At the bottom of the page, I would like a cell for each letter that tallies separately the total column of each of the letters and numbers

A44
B33
C77
D67

Can this be done? I hope I explained this clearly.

Many thanks to any wizards - much appreciated