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