Hi, I have what I hope is a simple question. I have attached a simplified version of what I am trying to do. In this first part I have four columns. Under the headers of the first three columns are drop down from a list. Each of the choices in the drop down has a corresponding point value to it.
As each drop down is selected, I want each of those point values to be added together and shown in the fourth column on the spreadsheet. Creating a drop down is not hard, adding the numbers together is not hard, what I don’t know is how to give an “alias” and say if Red in this cell then 10, but if green then 20, etc. I tried looking around at the formulas but can't seem to find what I am looking for. If anyone can point me in the right direction it would be great.
I attached a snippet of an excel file.
Thanks
Bookmarks