Im trying to create a survey, but have no idea how to calculate the answers:

I've made a list of categories, however there is no definite answers to the
questions e.g. It isn't multiple choice for example where I have given 5
possible answers and the person can only pick from these answers, it is left
to the person's own opinion.

Once I have a decent number of replies I can then sort out the most popular
responses.

The responses are in text form.

Do I have to come up with some numbers that represent each response to a
given question or can excel calculate text , finding certain words in answers
for example or would Access be better for this type of thing

Use COUNTIF(). Use five cell which counts the number of responses to each
question

=Countif(A1:A100,"Answer 1")
=Countif(A1:A100,"Answer 2")
=Countif(A1:A100,"Answer 3")
=Countif(A1:A100,"Answer 4")
=Countif(A1:A100,"Answer 5")


"tic" wrote:

Im trying to create a survey, but have no idea how to calculate the answers:

I've made a list of categories, however there is no definite answers to the
questions e.g. It isn't multiple choice for example where I have given 5
possible answers and the person can only pick from these answers, it is left
to the person's own opinion.

Once I have a decent number of replies I can then sort out the most popular
responses.

The responses are in text form.

Do I have to come up with some numbers that represent each response to a
given question or can excel calculate text , finding certain words in answers
for example or would Access be better for this type of thing

"Joel" wrote:

Use COUNTIF(). Use five cell which counts the number of responses to each
question

=Countif(A1:A100,"Answer 1")
=Countif(A1:A100,"Answer 2")
=Countif(A1:A100,"Answer 3")
=Countif(A1:A100,"Answer 4")
=Countif(A1:A100,"Answer 5")


"tic" wrote:

Im trying to create a survey, but have no idea how to calculate the answers:

I've made a list of categories, however there is no definite answers to the
questions e.g. It isn't multiple choice for example where I have given 5
possible answers and the person can only pick from these answers, it is left
to the person's own opinion.

Once I have a decent number of replies I can then sort out the most popular
responses.

The responses are in text form.

Do I have to come up with some numbers that represent each response to a
given question or can excel calculate text , finding certain words in answers
for example or would Access be better for this type of thing


Thanx I'll give it a try