# Need help with formula for charting results

1. ## 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. ## 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. ## 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. ## Re: Need help with formula for charting results

--
Don Guillett
SalesAid Software
donaldb@281.com
"SRS" <SRS@discussions.microsoft.com> wrote in message
> 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!

>>
>>
>>

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

#### 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