Comparing Two Rows and counting matches

N

nurice

Hey!
I have a spreadsheet of multiple-choice answers (answers are choices o
1,2,3,4) and an answer key on the top row. I want to be able to tall
how many matches each given row has with that first answer key row.

I've tried fidding around with COUNTIFS and such, but I can't seem t
get it to work properly. Any suggestions?

Thanks for your time;
-Nuric
 
D

DNF Karran

With the answer range in cells A1:C1 and the row of answers in A2:C2:

=COUNT(IF(A2:C2=A1:C1,A2:C2))

will do what you need and can be placed at the end of each row. Not
this is an array formula so must be entered using ctrl+shit+enter no
just enter.

Dunca
 
Top