formula SUMIF or whichever one will work for my issue

[Guest]

We sent out a survey and I need to make a database to enter the results. I
don't want to use Access. Some of the responses are H, M or N and I need a
formula that will allow me to find out how many H's, M's and N's are in the
sheet for each question.

Any suggestions?

THANKS!

 

[Guest]

Hi Richelle,

What you need to do is lay out your the data in your sheet so that there are
as many columns as the independent variables. For example if the question is
asked of Democrats/Republicans in a certain age group and in certain
house-hold income groups then Column A will be the Political Party
Affiliation, Column B could be the Age group to which the respondent belongs,
Column C the Household income group of the respondent and finally Column D is
the H/M/N answer.

Once you have data in this format, use the Pivot table for unlimited analysis.

 

[Jason Morin]

To count H's in col. B:

=COUNTIF(B:B,"H")

HTH
Jason
Atlanta, GA

 

[Guest]

Thanks for the help. I'm not sure if that works for what I have, so let me
give you more info and see if I'm just being dense because it's late in the
day.

I have 10 questions that have a possible answer of H, M or N. I just need
to be able to find out how many H's, how many M's and how many N's out of all
the responses. We've gotten almost 2000 responses so far, so it's going to be
a huge amount of information.

So, would your original post work for me still?

Thanks again!

 

[GerryK]

If your answers for 10 questions are in 10 columns
=SUMPRODUCT(--(A1:J2000="H")) in some cell on your sheet.

 

[Guest]

Richelle,

If all you want to do is tablulate how many H,M and N responses you got to
say Question 1 over the 2000 respondents and similarly for Questions 2 to 10
then
just lay out your data as follows

Resondent Column A: 1 to 2000 in rows 2 to 2001
Answer to Q1 in COlumn B
Answer to Q2 in COlumn C
and so on
Then you can just use the formula in Cell B2002
=countif(B2:B2001,"H")
In Cell B2003
=countif(B2:B2001,"M")
In Cell B2003
=countif(B2:B2001,"N")

You will then just need to copy these formulas to Columns C to ..

Hope this helps.