how many perfect score
 

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

how many perfect score
 

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.

how many perfect score
 

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

=COUNTIF(A1:A100,10)
--
Gary''s Student - gsnu200793


"James" wrote:

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

how many perfect score
 

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