Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
Solved

# Excel formula to count number of correct answers based on a key

Posted on 2013-01-28
Medium Priority
392 Views
Based on the attached example, what is the formula to total the number of correct answers for each person. Probably an array formula.

Thank You
0
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 2

LVL 24

Expert Comment

ID: 38828435

Will likely be using SUMIFS

Though pivot table may also be a good solution.
0

Author Comment

ID: 38828496
attached

preferably just a formula at the bottom of everyone's column of answers
Book1.xlsx
0

LVL 43

Accepted Solution

Saqib Husain, Syed earned 2000 total points
ID: 38828513
Enter this in A9 and copy across

=SUMPRODUCT((A2:A7=\$F\$2:\$F\$7)*1)
0

Author Closing Comment

ID: 38828532
many thanks
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
###### Suggested Courses
Course of the Month4 days, 12 hours left to enroll