# Thread: Calculate score correct out of total (WinXP XL2002)

1. ## Calculate score correct out of total (WinXP XL2002)

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.

2. ## Re: Calculate score correct out of total (WinXP XL2002)

In B2:
<pre>=COUNTIF(C2:V2,"C")/COUNTA(C2:V2)</pre>

Copy it down the column

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

3. ## Re: Calculate score correct out of total THANK YOU

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

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•