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