Comparing Two Rows and counting matches

  • Thread starter Thread starter nurice
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

counting blank cells within two columns 2
How can I count deviations between two rows? 3
Counting Cells with Multiple Range Criteria (Excel 2003) 7
Comparing Cells 1
Countif wrong in last row or two 3
comparing two columns 2
Counting how many numbers and letters appear in a particular row 7
count if a match occurs 1

Back
Top