Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Mar 2004
    Location
    London, Gtr London, England
    Posts
    299
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    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. #3
    3 Star Lounger
    Join Date
    Mar 2004
    Location
    London, Gtr London, England
    Posts
    299
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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
  •