Calculate score correct out of total (WinXP XL2002)

Topic

New Reply

I am scoring student marks for an exam, and need a formula to calculate the score. Each of 20 questions is either correct or incorrect, so the cells contain a C or an I to show this. I have a column to hold the final score as a fraction, ie 13 Cs out of 20. The formula need to count the number of Cs and put this as the top number in the fraction. I attach an example with fake data. Thanks in Advance.

Reply | Quote

Replies

In B2:

=COUNTIF(C2:V2,"C")/COUNTA(C2:V2)

Copy it down the column

Steve
PS or are you after?
=COUNTIF(C2:V2,”C”)&”/”&COUNTA(C2:V2)

Reply | Quote

Thankyou that does the job. The second formula also gives the bottom half of the fraction, ie the number of questions answered, a very useful addition

Reply | Quote