countif? or ifthen?

[rawdata89]

Hello,

I want to insert "yes'/"no" in columns I & J below based on if each row has 3 No's or 3 Yes's but the cells are non sequential, how would I write this? using a countif or an ifthen?

Required skills Met Yes	Required skills Met No	Total hours Count	Total hours Met Yes	Total hours Met No	# of hours - Have Less than 15	Required hourss Count Yes	Required hourss Count No	FLAG Y	FLAG N
YES		0​	YES		0​	YES		YES
	No	0​		No	0​		No		NO
YES		0​	YES		0​	YES		YES
	No	0​		No	0​		No		NO
	No	0​		No	0​		No		NO

 

[DanteAmor]

Welcome to the MrExcel forum. Please accept my warmest greetings and sincere hope that all is well.

How about:

Dante Amor
	A	B	C	D	E	F	G	H	I	J
1	Required skills Met Yes	Required skills Met No	Total hours Count	Total hours Met Yes	Total hours Met No	# of hours - Have Less than 15	Required hourss Count Yes	Required hourss Count No	FLAG Y	FLAG N
2	YES		0	YES		0	YES		YES
3		No	0		No	0		No		NO
4	YES		0	YES		0	YES		YES
5		No	0		No	0		No		NO
6		No	0		No	0		No		NO
Sh1

Cell Formulas
Range	Formula
I2:I6	I2	=IF(COUNTIF(A2:H2,"YES")=3,"YES","")
J2:J6	J2	=IF(COUNTIF(A2:H2,"NO")=3,"NO","")

--------------
I hope to hear from you soon.
Respectfully
Dante Amor
--------------

 

[etaf]

will the columns that you dont want to include have a YES or NO
if not then just use the full range

=countif(range , "YES")=3
with an IF

=IF(countif(range , "YES")=3, "YES","")

BUT what happens if you have more than 3 YES , is that possible