formula SUMIF or whichever one will work for my issue

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!
--
Richelle

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.


"Richelle" wrote:

> 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!
> --
> Richelle

To count H's in col. B:

=COUNTIF(B:B,"H")

HTH
Jason
Atlanta, GA

>-----Original Message-----
>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!
>--
>Richelle
>.
>

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!



"Alok" wrote:

> 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.
>
>
> "Richelle" wrote:
>
> > 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!
> > --
> > Richelle

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

>-----Original Message-----
>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!
>--
>Richelle
>.
>

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.

"Richelle" wrote:

> 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!
>
>
>
> "Alok" wrote:
>
> > 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.
> >
> >
> > "Richelle" wrote:
> >
> > > 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!
> > > --
> > > Richelle