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
Thanks PJ
Mock Test Version 1.xls | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | |||
1 | Q1 | Q2 | Q3 | Q4 | Q5 | Q6 | Q7 | Q8 | Q9 | Q10 | Q11 | Q12 | Q13 | |||
2 | 1.2 | 1.2 | 2.2 | 3.1 | 2.2 | 3.2 | 1.3 | 4.1 | 1.3 | 3.1 | 2.1 | 4.1 | 2.2 | |||
3 | C | E | D | C | E | A | B | D | E | E | E | E | D | |||
4 | C | D | D | C | B | A | D | D | E | B | C | A | C | |||
5 | C | A | D | C | B | A | B | D | E | B | C | D | D | |||
6 | C | A | D | C | B | A | D | D | E | B | B | D | C | |||
7 | C | A | D | C | B | A | D | D | E | A | C | D | D | |||
8 | C | A | D | C | B | A | D | D | E | B | C | D | C | |||
9 | A | D | C | E | A | D | D | E | D | C | D | B | ||||
10 | C | A | B | C | B | A | D | E | E | B | C | D | C | |||
11 | C | A | C | C | B | A | D | D | E | A | C | D | E | |||
12 | C | A | D | C | B | A | D | D | E | B | C | D | C | |||
13 | A | E | D | C | B | A | D | D | E | B | C | D | C | |||
14 | C | C | D | C | B | A | C | D | E | B | C | D | C | |||
15 | C | C | D | D | A | A | D | D | E | B | C | D | C | |||
16 | C | A | D | C | B | A | D | D | E | B | C | D | C | |||
17 | Answer Key | C | A | D | C | B | A | D | D | E | B | C | D | C | ||
rosa test |