title: Excel keep adding to total
body: <p>Hi I have been looking for 2 days and I cannot figure this out. I looked online everywhere, this little question is not answered anywhere. I have two drop down lists. One list for question and one for answers, when a question is selected the user then chooses an answer. If it it 'Always' its 1 mark and if its 'Sometimes' its 0.5 mark. I have a current set up in a different row ( on the far right) in many cells if the question is either of the two answers it gets the value 0.5 or 1. The only problem is when the user uses the drop down list to select the next question the if statement is now false and the value goes back to 0 instead of saving. I would like it to save the value after the value is higher then 1 or is there a better way to keep totaling up these answers and still keep my two drop down lists that work together?</p>
  
  <p>Thank you for taking the time to review my question and can't wait to learn how to do this, it has been driving me nuts.
  <img src="https://i.stack.imgur.com/aUL3a.png" alt="enter image description here"></p>