Try this:

=COUNTIF(A1:A100,10)

Adjust the range to suit.

--
Biff
Microsoft Excel MVP


"James" wrote in message
...
we use a score of 1 through 10 on our survey. i want to count how many
perfect 10's or in a range.