Can you help me setting up automatic scoring of a survey set up in MS Excel?

Dushen Naidoo February 21, 2012
Pinterest Stumbleupon Whatsapp

Hi All.

I would like your assistance.

I am creating a survey marking sheet and have array of different questions. I would like to have this done on MS Excel, however I am having difficulties with the formulas.

Column A consists of the question and column B is the scoring.
Within column B I would list a drop down list, which I am able to choose from 4 different options, i.e. Yes; No; Rated and N/A, however these respective text cells should be allocated to a score, i.e: if I select Yes it should score 5; if I select No, it should score 0, rated should score 2.5 and N/A should not score at all.

There are 15 questions, and from the above scoring it should automatically work out a percentage at the end.

I am able to work the formula’s separate, but I am having difficulty culminating it with the drop down list.

Please assist.

Ads by Google

  1. Karkala Nayak
    February 22, 2012 at 7:47 am

    Hello Dushen, 
    You can also check out this link.. to help you understand the concept
    http://www.ehow.com/how_5965189_tally-survey-results.html 

    AND on this website(link is provided below) There is a Creating Dropdown list input cells...subheading.. It has explained how to make a Dropdown list
    check out here click on the link below
    http://www.exceleverywhere.com/home/survey/index.htm 

    Other sites to help you
    http://www.brighthub.com/computing/windows-platform/articles/31430.aspx 
    http://www.contextures.com/xlform01.html 

    I hope it helped
    :)

  2. Susendeep Dutta
    February 22, 2012 at 7:19 am

    You can get to know all the required tips for creating a survey in the link below -

    http://www.microsoft.com/education/en-us/teachers/how-to/Pages/survey.aspx