Counting entries on condition

[rex759]

Hello,

I was using a COUNTIF formula to count the number of times a number starting with a 3 or 4 is found in a row. Works fine until someone’s ID appears more than once. Is it possible to have a formula add the rows together if duplicated without adding a helper column with unique entries? The results I am looking for are in column F.

This is the formula I was using

COUNTIF(B2:D2,3&"*")+COUNTIF(B2:D2,4&"*")

Book1
	A	B	C	D	E	F
1	ID	Input-1	Input-2	Input-3		Results
2	17777	33-2		44-1		2
3	17333	Audit	36-1			1
4	17444		47-1			1
5	17555	41-2				1
6	17666	32-1	33-9			3
7	17666			44-5
8	17987		36-7			1
Sheet1

 

[Peter_SSs]

Is this what you mean?

23 12 12.xlsm
	A	B	C	D	E	F	G
1	ID	Input-1	Input-2	Input-3		Results
2	17777	33-2		44-1		2	2
3	17333	Audit	36-1			1	1
4	17444		47-1			1	1
5	17555	41-2				1	1
6	17666	32-1	33-9			3	3
7	17666			44-5
8	17987		36-7			1	1
Count

Cell Formulas
Range	Formula
G2:G8	G2	=IF(COUNTIF(A$2:A2,A2)=1,SUMPRODUCT((A$2:A$8=A2)*((LEFT(B$2:D$8,1)="3")+(LEFT(B$2:D$8,1)="4"))),"")

 

[MicCh]

=if(countif("A$1:a1,a2),"",count(0/(s$2:a$8=a2)/(--left(b$2:d$8)={3,4}))

 

[rex759]

Thank you for the quick response! I tried Peter's first and it worked perfectly. Much appreciated

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.

(The other suggestion is not a valid formula so would not work - at least in its current form)