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