Thread: how many perfect score
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default 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.
Reply With QuoteReply With Quote