Hello. I am trying to find a way to have excel assign a numerical value to a word. I have a column in which I will either be entering a client's rate per session, or their insurance company. I would like to be able to tell excel that if I type in "BlueShield", that holds a value of 75 dollars.
At the bottom of the column I would like to have excel add up the values for a total. Is there any way to do this?
At the bottom of the column I would like to have excel add up the values for a total. Is there any way to do this?