How to Merge same name into one with indicator

[Tofik]

Hello everyone. Who can help me with one formula which can merge 2 Items with status into one. Also I have special indicator which helps me with process and show me what complete or no .
Indicators split in 2 groups:
1-st one 1 &6 .
2-d one 2 & 3 & 4 & 5 .

Condition should be next for SUM indicator Cell ( 1 & 6 and 2 & 3 & 4 & 5 the same rule )
If there all cells N/A it should show to me N/A
If most N/A and some YES then it show YES
If in all cells different(N/A and YES ) but have NO then show NO
If in all cells different(N/A and YES , NO ) but have REJ then show REJ

TRY USER W.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L
1	What I Have								What I need as addition for the product.
2	Product Name	Indicator 1 Fresh	Indicator 2 Juicy	Indicator 3 Good Condition	Indicator 4 Dimension	Indicator 5 Certificate	Indicator6 Price		Product Name	SUM Indicator 2 & 3 & 4 & 5	SUM Indicator 1 & 6
3	Apple	N/A	YES	YES	YES	N/A	N/A		Apple	NO	NO
4	Apple	YES	YES	N/A	N/A	NO	N/A		Banana	YES	YES
5	Banana	YES	YES	N/A	N/A	N/A	N/A		Strawberry	N/A	REJ
6	Strawberry	N/A	N/A	N/A	N/A	N/A	REJ
7	Apple	N/A	YES	N/A	YES	N/A	NO
8	Banana	N/A	N/A	N/A	N/A	N/A	N/A
9	Banana	N/A	N/A	N/A	N/A	N/A	YES
10
11
12
13
14
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
J3:K5	Cell Value	="REJ"	text	NO
J3:K5	Cell Value	="NO"	text	NO
J3:K5	Cell Value	="YES"	text	NO
B3:G9	Cell Value	="REJ"	text	NO
B3:G9	Cell Value	="NO"	text	NO
B3:G9	Cell Value	="YES"	text	NO

Thank you.