Countif number in cell is higher than number in corresponding cell

[dewotorf]

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

 

[Habtest]

Hi there, try this below. The first condition is for column comparison, the second to ensure it's a number column C.

Book1
	A	B	C
1
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
60
61			18
Sheet1

Cell Formulas
Range	Formula
C61	C61	=SUMPRODUCT((C3:C59>B3:B59)*ISNUMBER(C3:C59))

 

[jtakw]

Hi,

From OP's previous thread here COUNTIFS WITH NUMERIC CONSTRAINT
in case there're blanks in B Column, may be this:

Book3.xlsx
	A	B	C	D	E	F
1	Candidate	Test1	Test2
2	AB1	7	n/a		Count	17
3	AB2	3	n/a
4	AB3	3	n/a
5	AB4	3	n/a
6	AB5	3	7
7	AB6	3	7
8	AB7	3	7
9	AB8		7
10	AB9	ab	3
11	AB10		3
12	AB11	1	7
13	AB12	3	7
14	AB13	1	DO
15	AB14	ab	3
16	AB15	ab	7
17	AB16	1	3
18	AB17	ab	7
19	AB18	ab	7
20	AB19	3	7
21	AB20	ab	3
22	AB21	ab	DO
23	AB22	ab	1
24	AB23	ab	3
25	AB24	ab	1
26	AB25	ab	2
27	AB26	2	7
28	AB27	1	2
29	AB28	1	3
30	AB29	1	DO
31	AB30	3	3
32	AB31	1	3
33	AB32	3	3
34	AB33	ab	1
35	AB34	1	7
36	AB35	3	3
37	AB36	1	1
38	AB37	7	do
39	AB38	1	do
40	AB39	DO	DO
41	AB40	1	7
42	AB41	3	7
43	AB42	3	7
44	AB43	3	7
45	AB44	3	3
46	AB45	ab	7
47	AB46	3	n/a
48	AB47	3	7
49	AB48	ab	7
50	AB49	7	3
51	AB50	3	n/a
52	AB51	1	n/a
53	AB52	7	n/a
54	AB53	3	n/a
55	AB54	3	n/a
56	AB55	7	n/a
57	AB56	3	n/a
58	AB57	3	n/a
59
60
Sheet800

Cell Formulas
Range	Formula
F2	F2	=SUMPRODUCT((ISNUMBER(C2:C60)*(B2:B60<>"")*(C2:C60>B2:B60)))

 

[dewotorf]

Hi there, try this below. The first condition is for column comparison, the second to ensure it's a number column C.

Book1
	A	B	C
1
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
60
61			18
Sheet1

Cell Formulas
Range	Formula
C61	C61	=SUMPRODUCT((C3:C59>B3:B59)*ISNUMBER(C3:C59))

This worked perfectly. Much appreciated

 

[dewotorf]

This worked perfectly. Much appreciated

I can't find where to do this on my page