Count Correct

planetpj

Active Member
Joined
Jun 25, 2002
Messages
351
Good afternoon. What I am trying to do is count all of the right answers per strand. Our strands start in our second row. What I would like to do is to has a formulas that generates that strand 1.2 has 21 correct answers 2.2 has 32 corect answers. Can anyone help me >
Thanks PJ
Mock Test Version 1.xls
ABCDEFGHIJKLMN
1Q1Q2Q3Q4Q5Q6Q7Q8Q9Q10Q11Q12Q13
21.21.22.23.12.23.21.34.11.33.12.14.12.2
3CEDCEABDEEEED
4CDDCBADDEBCAC
5CADCBABDEBCDD
6CADCBADDEBBDC
7CADCBADDEACDD
8CADCBADDEBCDC
9ADCEADDEDCDB
10CABCBADEEBCDC
11CACCBADDEACDE
12CADCBADDEBCDC
13AEDCBADDEBCDC
14CCDCBACDEBCDC
15CCDDAADDEBCDC
16CADCBADDEBCDC
17Answer KeyCADCBADDEBCDC
rosa test
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
For 1.2

=SUM((B2:N2=1.2)*(B3:N16=B17:N17))

confirmed with CTRL+SHIFT+ENTER

substitute other values for 1.2 or use cell references
 
Upvote 0
Book3
ABCD
19
20StrandCorrect Count
211.221
222.232
233.123
243.214
251.325
264.125
272.112
28
rosa test


B21:

=SUM(IF($B$2:$N$2=A21,IF($B$3:$N$16=$B$17:$N$17,1)))

which is confirmed with control+shift+enter (not just with enter) then copied down.
 
Upvote 0

Forum statistics

Threads
1,213,557
Messages
6,114,293
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top