title: Adding named variables in separate Excel cells
body: <p>I am creating a game in which an object can have different conditions throughout a level. Each condition has a numeric value. In the left column I have the list of conditions such as RED, GREEN, BLUE, TAN, ORANGE. In the right column I have given each of those conditions a value of 1 through 5. </p>
  
  <p>Using this as a key, I would like to go through the game, level by level, marking down all of the conditions that object encounters per level.</p>
  
  <p>For example, In level 1 the Object can be RED, BLUE, ORANGE. In an Excel row, I want to, in separate cells, mark which conditions are encountered. So B2 would be "RED", C2 would be "BLUE" and D2 would be "ORANGE". Then I want to be able to add up those cells to know what the sum of those condition values are. </p>
  
  <p>I have been able, in Name Manager, to assign values to names but I am unable to add separate cells with the condition names together. I am only able to do this as a equation inside of a single cell using "= RED + BLUE + ORANGE" However, it is then difficult, visually, to see all  of the conditions for each level, it only shows the total value in the cell containing the equation. </p>
  
  <p>Thank you very much for your help. Let me know if any additional clarification is needed. </p>