Consider the table below. I want to count only cells in column C where the number is higher than the number in the corresponding cell in column B. Any advice on the code to use will be very much appreciated;
countifsnumber.xlsx | |||||
---|---|---|---|---|---|
A | B | C | |||
2 | Candidate | Test1 | Test2 | ||
3 | AB1 | 7 | n/a | ||
4 | AB2 | 3 | n/a | ||
5 | AB3 | 3 | n/a | ||
6 | AB4 | 3 | n/a | ||
7 | AB5 | 3 | 7 | ||
8 | AB6 | 3 | 7 | ||
9 | AB7 | 3 | 7 | ||
10 | AB8 | ab | 7 | ||
11 | AB9 | ab | 3 | ||
12 | AB10 | 2 | 3 | ||
13 | AB11 | 1 | 7 | ||
14 | AB12 | 3 | 7 | ||
15 | AB13 | 1 | DO | ||
16 | AB14 | ab | 3 | ||
17 | AB15 | ab | 7 | ||
18 | AB16 | 1 | 3 | ||
19 | AB17 | ab | 7 | ||
20 | AB18 | ab | 7 | ||
21 | AB19 | 3 | 7 | ||
22 | AB20 | ab | 3 | ||
23 | AB21 | ab | DO | ||
24 | AB22 | ab | 1 | ||
25 | AB23 | ab | 3 | ||
26 | AB24 | ab | 1 | ||
27 | AB25 | ab | 2 | ||
28 | AB26 | 2 | 7 | ||
29 | AB27 | 1 | 2 | ||
30 | AB28 | 1 | 3 | ||
31 | AB29 | 1 | DO | ||
32 | AB30 | 3 | 3 | ||
33 | AB31 | 1 | 3 | ||
34 | AB32 | 3 | 3 | ||
35 | AB33 | ab | 1 | ||
36 | AB34 | 1 | 7 | ||
37 | AB35 | 3 | 3 | ||
38 | AB36 | 1 | 1 | ||
39 | AB37 | 7 | do | ||
40 | AB38 | 1 | do | ||
41 | AB39 | DO | DO | ||
42 | AB40 | 1 | 7 | ||
43 | AB41 | 3 | 7 | ||
44 | AB42 | 3 | 7 | ||
45 | AB43 | 3 | 7 | ||
46 | AB44 | 3 | 3 | ||
47 | AB45 | ab | 7 | ||
48 | AB46 | 3 | n/a | ||
49 | AB47 | 3 | 7 | ||
50 | AB48 | ab | 7 | ||
51 | AB49 | 7 | 3 | ||
52 | AB50 | 3 | n/a | ||
53 | AB51 | 1 | n/a | ||
54 | AB52 | 7 | n/a | ||
55 | AB53 | 3 | n/a | ||
56 | AB54 | 3 | n/a | ||
57 | AB55 | 7 | n/a | ||
58 | AB56 | 3 | n/a | ||
59 | AB57 | 3 | n/a | ||
Sheet2 |