Thread: How to put test questions then student answers and get % correct
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default How to put test questions then student answers and get % correct
Assuming student names in column A, and column B their scores, and column C
either have "y" for correct answer, "n" for wrong answer

In D2: =COUNTIF(C2:C10,"y")/COUNTA(C2:C10)


"Kathy" wrote:

I need to make a sheet with test questions and answers. Then I need to put
in all students and their answers. Afterwards I need it to caluate the
percentage that was correct. Can anyone help?
Reply With QuoteReply With Quote