+ Reply to Thread
Results 1 to 3 of 3

Tallying a multiple choice test

  1. #1
    Registered User
    Join Date
    06-06-2014
    Posts
    2

    Tallying a multiple choice test

    Columns represent each student's test (There are 31 test numbers)
    The test consisted of 50 multiple choice questions, each listed in each row. The green column shows the correct answer for each question.

    I need to tally the score for each test in the orange row. How do I tally by checking each answer against the correct answer? (The three tan columns should have the highest scores) Thank you in advance.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,576

    Re: Tallying a multiple choice test

    In B52 copied to the right, enter this ARRAYED formula

    =SUM(--(B2:B51=$AG$2:$AG$51))/50

    ...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
    ChemistB
    My 2

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Registered User
    Join Date
    06-06-2014
    Posts
    2

    Re: Tallying a multiple choice test

    Worked great, thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 12-16-2013, 05:16 AM
  2. In need of a template multiple choice test database
    By desnyder2001 in forum Access Tables & Databases
    Replies: 2
    Last Post: 09-01-2013, 10:56 PM
  3. Multiple Time Stamps depending on choice in Drop Down List Choice
    By insayah in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-13-2011, 10:18 PM
  4. Grading a multiple choice test in Excel
    By mburch in forum Excel General
    Replies: 2
    Last Post: 06-10-2008, 02:30 PM
  5. [SOLVED] help - create a multiple choice test
    By robynhaga@gmail.com in forum Excel General
    Replies: 2
    Last Post: 07-17-2006, 07:35 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1