This is my first post so please accept my apologies if I have posted this question incorrectly . I am using Excel 2010 and I have produced a check sheet form for work in which questions are answered from drop down list in cells C13:15,19,21,23,25,29,31,31,35 and this generates a 1 or 0 answer in the corresponding cells in column E. I want a formula to automatically add the scores up and show this in cell B60. I have linked cells A to D 61,62,63,64,65 as a table of automatic final outcomes based on the number of the score generated by responses to questions in C13:C35.As it stands at the minute if I manually total the score and fill cell B60 the correct row in the table is highlighted to provide the automatic response. I can attach the form if that would help. Thanks and sorry for if the question is too long