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