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.
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
Worked great, thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks