Please help! about Dynamic Conditioning

[pistonss]

Hello All,

I have a question. If I want to create one last column (in this case it's called "Criteria Met?") in which it will show "Yes" if the conditions on its left are shown "Yes" as well. However, I want to be able to choose which of the 4 conditions I want the last column to take into consideration. And the way I'm gonna do that is to put number "1" on top of each conditions' columns; meaning if a condition doesn't have "1" on top of its column, I don't want my last column to even take it as one of the criteria in order to show "Yes". Is it possible to a kind of dynamic conditioning like this? Thank you

	1		1	1
Item	Condition 1	Condition 2	Condition 3	Condition 4	Criteria met?
A	Yes	Yes	Yes	Yes
B				Yes
C	Yes	Yes
D	Yes	Yes	Yes	Yes
E	Yes		Yes	Yes
F
G				Yes
H			Yes
I	Yes	Yes	Yes	Yes

<colgroup><col><col span="5"></colgroup><tbody>
</tbody>

 

[Peter_SSs]

Is this, copied down, what you mean?

Book1
	A	B	C	D	E	F
1		1		1	1
2	Item	Condition 1	Condition 2	Condition 3	Condition 4	Criteria met?
3	A	Yes	Yes	Yes	Yes	Yes
4	B				Yes
5	C	Yes	Yes
6	D	Yes	Yes	Yes	Yes	Yes
7	E	Yes		Yes	Yes	Yes
8	F
9	G				Yes
10	H			Yes
11	I	Yes	Yes	Yes	Yes	Yes
Conditions met

Cell Formulas
Range	Formula
F3	=IF(COUNTIFS(B$1:E$1,1,B3:E3,"Yes")=COUNTIF(B$1:E$1,1),"Yes","")