title: Excelc calculate a value based on dropdown list selection
body: <p>Novice excel user here. I am working with Excel 2013</p>
  
  <p>I have 11 cells in a row with dropdown lists.  The drop down lists have 6 texts values:
  Choose One
  Exceptional
  Excellent
  Successfull
  Needs Improvement
  Unsuccessful</p>
  
  <p>Depending one which is chosen they need to have values of 5 (exceptional) to 1 (Unsuccessful) and 0 being (Choose One).  Some cells may only have Choose One (being not selected).  I need to add the add up the total values of what is selected.  So if 5 were "Selected", 4 were "Excellent" and 2 were Choose One, the total would be 31.  I need to calculate the value of 31 / the number selected which in this case is 9 to equal 3.44. How do I create a formula in a cell to take all of that into consideration?</p>
  
  <p>Thoughts?</p>
  
  <p>Thanks in advance.</p>