Count Correct

planetpj

Active Member
Joined
Jun 25, 2002
Messages
347
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

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

barry houdini

MrExcel MVP
Joined
Mar 23, 2005
Messages
20,825
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
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,209
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.
 

Forum statistics

Threads
1,136,272
Messages
5,674,749
Members
419,525
Latest member
helensesc

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
Top