how many perfect score

[James]

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

 

[T. Valko]

Try this:

=COUNTIF(A1:A100,10)

Adjust the range to suit.

 

[Gary''s Student]

If the scores are in column A in A1 thru A100, then:

=COUNTIF(A1:A100,10)

 

[Dave]

Hi,
If the range is A2:A200
=COUNTIF(A2:A200,10)
Change range to suit your data.
Regards - Dave.