Substituting numbers for letters and totalling value

[Lexce]

I would like to put any one of 20 different text strings in a row of 6 cells, where each text string has been given a different numerical value.

As I enter a text string into a cell, (only one per cell) the numerical value would appear in box 7 at the end of the row. Each text string entered would increase the numerical total at the end of the row.

I want to print out the result so that boxes 1 - 6 show text strings and box 7 shows the total of all the numerical values equivalent to the text strings

The numerical value of each of the text strings can be listed somewhere on the page

[DonkeyOte]

If for arguments sake your 20 strings and associated values were listed in A1:B20 (strings in A, values in B) and your 6 strings were to be placed in say A21:F21 with total in G21

G21: =SUMPRODUCT(COUNTIF(A21:F21,A1:A20),B1:B20)

[Domenic]

Here's a similar way...

=SUMPRODUCT(SUMIF($A$1:$A$20,A21:F21,$B$1:$B$20))

[Lexce]

Thank you for those answers.
I'm humbled by the amount of knowledge some people have
QED