Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
196
Views
Topic starter
I'm making a class quiz with 40 multiple-choice items. The value of each question is one point. In Excel, I need a formula to add up each 3 wrong answers and reduce one extra point from the total. For example, if the test taker has answered 37/40 questions correct, he should receive a score of 36. In this way he has lost one extra score for his wrong responses. I wonder if you could kindly help me out.
Thank you.
Posted : 15/04/2020 10:53 pm
Hi Mohammad,
Thanks for sharing the file. You can use COUNTIF for this:
=SUM(COUNTIF(C3:AZ3,$C$2:$AZ$2))
You may need to enter it with CTRL+SHIFT+ENTER if you're not using Office 365.
Mynda
Posted : 15/04/2020 11:25 pm
