Tallying Survey answer

[zloep]

I have a survey with 10 questions, filled out by roughly 25 individuals. Each question asks the individual to rank their thoughts from 1 (poor) to 10 (excellent).

From cell A1 to Y1, I've inputed the answers to question 1. It goes something like this:

10 9 10 9 8 10 7 4 10 9 8 7 4 10 8 10....

Is there a simply formula I can use to count how many "10", "9", "8" ... etc. were entered between A1:Y1"?

 

[Special-K99]

=countif($a$1:$y$1,10)

will count 10s in that range
numbers other than 10 will count whatever the other numebrs are

 

[T. Valko]

List the unique numbers 1 - 10 in a range of cells. Assume that list is in the range A5:A14.

Enter this formula in B5 and copy down to B14:

=COUNTIF(A$1:Y$1,A5)