| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding up letter values
Excel 2007;
I am looking for help with a formula that would let me add the values of letters in a cell. ie. cells A1 - A4 have the letters A or B or C or D, the letter A = 1 point, the letter B = 2 points, the letter C = 3 points, and the letter D = 4 points. In cell A7 I need a total of all the points - in this case the total would be 10 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding letter at the end of cell | Excel Discussion (Misc queries) | |||
| Dificulty adding alphanumeric values either one letter or two | New Users to Excel | |||
| Adding Cells with a letter in one of them | Excel Discussion (Misc queries) | |||
| Adding a number to a letter of the alphabet to get a letter | Excel Worksheet Functions | |||
| Adding A range of cells that have a certain text letter | Excel Worksheet Functions | |||
Threaded Mode
