# Count Correct

#### planetpj

##### Active Member
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
14CCDCBACDEBCDC
rosa test

### Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand
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

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.

Thank you both!

Replies
0
Views
429
Replies
9
Views
723
Replies
1
Views
317
Replies
1
Views
570
Replies
1
Views
230

1,211,803
Messages
6,104,074
Members
447,892
Latest member

### 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.

### Which adblocker are you using?

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

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