COUNTIFS WITH NUMERIC CONSTRAINT

[dewotorf]

Hi All,
I am looking for a way to count a specific number in a column provided the corresponding cell in another column is a number i.e.(not text). Consider the table below as an example;

I want to count only 70% marks in column B provided the corresponding value in column C is a number. In this case the answer will be 2.

 

[dewotorf]

1 problem though is that the code counts blank cells as zero

So, are you saying you may use 0 as the Count criteria?

Is this what you mean, added another test for Blanks:

Book3.xlsx
	A	B	C	D	E	F
1	Candidate	Test 1	Test 2		Criteria	0
2	AB1	7	n/a		Count	0
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	ab	7
10	AB9	ab	3
11	AB10	2	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
39	AB38	1
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			0
60
Sheet798

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

Yes please

 

[jtakw]

Did you try the formula in Post #10?