Need help obtaining a formula

[mrafiq44]

So on the row i have different people such as Person A, Person B, Person C, etc.
And on the columns i have their duties such as - Cleaning, Drying, Building, Examining
So an example would be person A - Cleaning (Yes), Drying (No), Building (Yes), Examining (No)
Some of these duties are high level such as Cleaning and Drying - so i want to create a formula that a column in the end that would be Column 5 shows Yes because person A does perform a high level task.
Can someone please help me with this formula?

 

[Cubist]

Something like this?

Book2
	A	B	C	D	E	F
1		Cleaning	Drying	Building	Exmaining	High Level Task?
2	Person A	Yes	No	Yes	No	YES
3	Person B	No	No	Yes	Yes	NO
4	Person C	Yes	Yes	Yes	No	YES
Sheet9

Cell Formulas
Range	Formula
F2:F4	F2	=IF(COUNTIFS(B2:C2,"Yes"),"YES","NO")

 

[mrafiq44]

Something like this?

Book2
	A	B	C	D	E	F
1		Cleaning	Drying	Building	Exmaining	High Level Task?
2	Person A	Yes	No	Yes	No	YES
3	Person B	No	No	Yes	Yes	NO
4	Person C	Yes	Yes	Yes	No	YES
Sheet9

Cell Formulas
Range	Formula
F2:F4	F2	=IF(COUNTIFS(B2:C2,"Yes"),"YES","NO")

[/

Something like this?

Book2
	A	B	C	D	E	F
1		Cleaning	Drying	Building	Exmaining	High Level Task?
2	Person A	Yes	No	Yes	No	YES
3	Person B	No	No	Yes	Yes	NO
4	Person C	Yes	Yes	Yes	No	YES
Sheet9

Cell Formulas
Range	Formula
F2:F4	F2	=IF(COUNTIFS(B2:C2,"Yes"),"YES","NO")

what if its different columns that are not together?

Cell Formulas
Range	Formula

 

[mrafiq44]

Something like this?

Book2
	A	B	C	D	E	F
1		Cleaning	Drying	Building	Exmaining	High Level Task?
2	Person A	Yes	No	Yes	No	YES
3	Person B	No	No	Yes	Yes	NO
4	Person C	Yes	Yes	Yes	No	YES
Sheet9

Cell Formulas
Range	Formula
F2:F4	F2	=IF(COUNTIFS(B2:C2,"Yes"),"YES","NO")

What is the columns are A and D?

 

[Cubist]

What is the columns are A and D?

If you have only 2 targeted columns, then you can try the below. If there are a lot more then there might be a more concise syntax depending on your version of XL.

Book2
	A	B	C	D	E	F
1		Cleaning	Building	Drying	Examaining	High Level Task?
2	Person A	Yes	Yes	No	No	Yes
3	Person B	No	Yes	No	Yes	No
4	Person C	Yes	Yes	Yes	No	Yes
Sheet9

Cell Formulas
Range	Formula
F2:F4	F2	=IF((B2="Yes")+(D2="Yes"),"Yes","No")

 

[Scott Huish]

What is the columns are A and D?

Isn't column A the person's name?

 

[mrafiq44]

If you have only 2 targeted columns, then you can try the below. If there are a lot more then there might be a more concise syntax depending on your version of XL.

Book2
	A	B	C	D	E	F
1		Cleaning	Building	Drying	Examaining	High Level Task?
2	Person A	Yes	Yes	No	No	Yes
3	Person B	No	Yes	No	Yes	No
4	Person C	Yes	Yes	Yes	No	Yes
Sheet9

Cell Formulas
Range	Formula
F2:F4	F2	=IF((B2="Yes")+(D2="Yes"),"Yes","No")

Thank you so much!!! Saved me a ton of time.

 

[mrafiq44]

Thank you so much!!! Saved me a ton of time. Another question - what is there is other condition in a column where is the person is a Carpenter i.e. job position he should not be a part of this formula and the answer should be a no even if the formula gives a yes

 

[Scott Huish]

If you end up having more, you could insert a row at the top, and above each column that is a HIGH level job, put the word HIGH, and then you could do this:

=IF(COUNTIFS(B3:E3,"Yes",$B$1:$E$1,"HIGH"),"YES","NO")

	HIGH		HIGH
	Cleaning	Drying	Building	Exmaining	High Level Task?
Person A	Yes	No	Yes	No	YES
Person B	No	No	No	Yes	NO
Person C	Yes	Yes	Yes	No	YES

 

[Cubist]

Thank you so much!!! Saved me a ton of time. Another question - what is there is other condition in a column where is the person is a Carpenter i.e. job position he should not be a part of this formula and the answer should be a no even if the formula gives a yes

Book2
	A	B	C	D	E	F	G
1	Person	Position	Cleaning	Building	Drying	Examaining	High Level Task?
2	Person A	Carpenter	Yes	Yes	No	No	No
3	Person B	Janitor	No	Yes	No	Yes	No
4	Person C	Manager	Yes	Yes	Yes	No	Yes
Sheet9

Cell Formulas
Range	Formula
G2:G4	G2	=IF((B2<>"Carpenter")*((C2="Yes")+(E2="Yes")),"Yes","No")