+ Reply to Thread
Results 1 to 4 of 4

Need help with formula for charting results

  1. #1
    SRS
    Guest

    Need help with formula for charting results

    I'm a newbie with Excel and I know this should be easy, but I just can't
    figure it out.

    We sent out a questionaire to 50 people with 20 questions (all multiple
    choice - 4 possible answers, A,B,C or D)

    I've made a spreadsheet with all the reponses. Now I want to make a chart
    that says here's how many people responded 'A' to question 1, 'B to question
    1, and so forth. So basically, there's 4 bars (a-d) for each question and
    the value for each bar is the number of times that answer was chosen.

    I know I need to make a formula to count the reponses for each question, but
    can't figure it out. Can you help?

    Thank you!

  2. #2
    Don Guillett
    Guest

    Re: Need help with formula for charting results

    have a look in help index for COUNTIF

    --
    Don Guillett
    SalesAid Software
    donaldb@281.com
    "SRS" <SRS@discussions.microsoft.com> wrote in message
    news:477F452D-0433-4EAA-B6D8-23FFCDAF7824@microsoft.com...
    > I'm a newbie with Excel and I know this should be easy, but I just can't
    > figure it out.
    >
    > We sent out a questionaire to 50 people with 20 questions (all multiple
    > choice - 4 possible answers, A,B,C or D)
    >
    > I've made a spreadsheet with all the reponses. Now I want to make a chart
    > that says here's how many people responded 'A' to question 1, 'B to
    > question
    > 1, and so forth. So basically, there's 4 bars (a-d) for each question and
    > the value for each bar is the number of times that answer was chosen.
    >
    > I know I need to make a formula to count the reponses for each question,
    > but
    > can't figure it out. Can you help?
    >
    > Thank you!




  3. #3
    SRS
    Guest

    Re: Need help with formula for charting results

    Don:
    THANK YOU...found all my answers there. I knew the answer was right in
    front of me. Thanks again!

    "Don Guillett" wrote:

    > have a look in help index for COUNTIF
    >
    > --
    > Don Guillett
    > SalesAid Software
    > donaldb@281.com
    > "SRS" <SRS@discussions.microsoft.com> wrote in message
    > news:477F452D-0433-4EAA-B6D8-23FFCDAF7824@microsoft.com...
    > > I'm a newbie with Excel and I know this should be easy, but I just can't
    > > figure it out.
    > >
    > > We sent out a questionaire to 50 people with 20 questions (all multiple
    > > choice - 4 possible answers, A,B,C or D)
    > >
    > > I've made a spreadsheet with all the reponses. Now I want to make a chart
    > > that says here's how many people responded 'A' to question 1, 'B to
    > > question
    > > 1, and so forth. So basically, there's 4 bars (a-d) for each question and
    > > the value for each bar is the number of times that answer was chosen.
    > >
    > > I know I need to make a formula to count the reponses for each question,
    > > but
    > > can't figure it out. Can you help?
    > >
    > > Thank you!

    >
    >
    >


  4. #4
    Don Guillett
    Guest

    Re: Need help with formula for charting results

    glad it helped


    --
    Don Guillett
    SalesAid Software
    donaldb@281.com
    "SRS" <SRS@discussions.microsoft.com> wrote in message
    news:EB101272-BBAF-4449-AD76-ED777D2D541F@microsoft.com...
    > Don:
    > THANK YOU...found all my answers there. I knew the answer was right in
    > front of me. Thanks again!
    >
    > "Don Guillett" wrote:
    >
    >> have a look in help index for COUNTIF
    >>
    >> --
    >> Don Guillett
    >> SalesAid Software
    >> donaldb@281.com
    >> "SRS" <SRS@discussions.microsoft.com> wrote in message
    >> news:477F452D-0433-4EAA-B6D8-23FFCDAF7824@microsoft.com...
    >> > I'm a newbie with Excel and I know this should be easy, but I just
    >> > can't
    >> > figure it out.
    >> >
    >> > We sent out a questionaire to 50 people with 20 questions (all multiple
    >> > choice - 4 possible answers, A,B,C or D)
    >> >
    >> > I've made a spreadsheet with all the reponses. Now I want to make a
    >> > chart
    >> > that says here's how many people responded 'A' to question 1, 'B to
    >> > question
    >> > 1, and so forth. So basically, there's 4 bars (a-d) for each question
    >> > and
    >> > the value for each bar is the number of times that answer was chosen.
    >> >
    >> > I know I need to make a formula to count the reponses for each
    >> > question,
    >> > but
    >> > can't figure it out. Can you help?
    >> >
    >> > Thank you!

    >>
    >>
    >>




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1