What is your data layout?
If very good, good, not good, not good at all are in, say column A in
separate cells like below

minÅ‘sÃ*tés
very good
good
not good
not good at all
good
good
good
not good
not good
not good
not good
not good at all
not good at all
not good at all
very good
very good
very good
very good
very good

Then
count them in this way:

Place different values in, say column B, and enter formula in C1:

=COUNTIF(A:A,B1)

Result shall look like this:

B C
very good 6
good 4
not good 5
not good at all 4

Regards,
Stefi


€žDJ€� ezt Ã*rta:

Got huge list of responses to survey - they a very good, good, not good,
not good at all. Problem I have is that when I try to count how many instance
of say good there are sheet counts all that have good i.e. very good, not
very good etc - can anyone help me?
--
DJ