Excel 2000 Counting occurrances

[Paul]

I'd like to count the number of specific responses to a specific question in
a questionnaire where I have 100 respondents and have the info on one excel
sheet
e.g
I'd like to be able to get the following information:
Question 1 had 42 responses of "Agree", 7 responses of "Neutral", 18
responses of "Disagree"...etc
Question 2 had "90" responses of "Strongly agree", 2 responses of "Disagree"

I'm struggling with the formulas
Can you help?

[Dave Peterson]

Maybe using the =countif() function:

=countif(a1:a99,"Agree")



Paul wrote:
>
> I'd like to count the number of specific responses to a specific question in
> a questionnaire where I have 100 respondents and have the info on one excel
> sheet
> e.g
> I'd like to be able to get the following information:
> Question 1 had 42 responses of "Agree", 7 responses of "Neutral", 18
> responses of "Disagree"...etc
> Question 2 had "90" responses of "Strongly agree", 2 responses of "Disagree"
>
> I'm struggling with the formulas
> Can you help?

--

Dave Peterson

[Paul]

Hi Dave,
I'd like to be able to say COUNTIF() When question is "1"
So I can get the individual question responses for mulitple questions
Thanks

"Dave Peterson" wrote:

> Maybe using the =countif() function:
>
> =countif(a1:a99,"Agree")
>
>
>
> Paul wrote:
> >
> > I'd like to count the number of specific responses to a specific question in
> > a questionnaire where I have 100 respondents and have the info on one excel
> > sheet
> > e.g
> > I'd like to be able to get the following information:
> > Question 1 had 42 responses of "Agree", 7 responses of "Neutral", 18
> > responses of "Disagree"...etc
> > Question 2 had "90" responses of "Strongly agree", 2 responses of "Disagree"
> >
> > I'm struggling with the formulas
> > Can you help?
>
> --
>
> Dave Peterson
>

[Dave Peterson]

Maybe...

=sumproduct(--(a1:a99=1),--(b1:b99="agree"))

Adjust the ranges to match--but you can't use whole columns.

=sumproduct() likes to work with numbers. The -- stuff changes trues and falses
to 1's and 0's.

Bob Phillips explains =sumproduct() in much more detail here:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

And J.E. McGimpsey has some notes at:
http://mcgimpsey.com/excel/formulae/doubleneg.html

Paul wrote:
>
> Hi Dave,
> I'd like to be able to say COUNTIF() When question is "1"
> So I can get the individual question responses for mulitple questions
> Thanks
>
> "Dave Peterson" wrote:
>
> > Maybe using the =countif() function:
> >
> > =countif(a1:a99,"Agree")
> >
> >
> >
> > Paul wrote:
> > >
> > > I'd like to count the number of specific responses to a specific question in
> > > a questionnaire where I have 100 respondents and have the info on one excel
> > > sheet
> > > e.g
> > > I'd like to be able to get the following information:
> > > Question 1 had 42 responses of "Agree", 7 responses of "Neutral", 18
> > > responses of "Disagree"...etc
> > > Question 2 had "90" responses of "Strongly agree", 2 responses of "Disagree"
> > >
> > > I'm struggling with the formulas
> > > Can you help?
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson