Is there a way that you can have a word representing a number and then add up the number at the end of the row but leaving the word showing in its cell? For example: If "Red" was written in a cell and I wanted the word "Red" to represent the number 3 but still only seeing the word "Red" in the cell. And then being able to add up the number 3 along with similar number-representing words at the end of the row. Please help
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Excel Function
- Thread starter tester
- Start date
Good evening tester
You would have to have a table listed somewhere, with all your colours listed vertically in one column and the numbers they represent in an adjacent column.
Then at the end of the row, you would use a VLOOKUP formula to retrieve the number that the word represents.
HTH
DominicB
You would have to have a table listed somewhere, with all your colours listed vertically in one column and the numbers they represent in an adjacent column.
Then at the end of the row, you would use a VLOOKUP formula to retrieve the number that the word represents.
HTH
DominicB