If A1:K1= yes then yes = 5%

[bodew]

I want to make a team evaluation table. Once an employee meets a criterion and has a "yes" answer, then that answer should carry 5% towards the evaluation.
Example:
Cells A1:K1 contain different criterion
A1: Organizational skills
A2: Communication skills
A3: Teamwork skills

I want the answer :yes: in cell A2 under criterion A1- to carry 5% to the employee's evaluation

I would like the answer :yes: in box B2 under criterion B2- to contribute 10% to the employee's evaluation and so on.
Then, depending on the YES answers, the employee should receive a total score in cell L1, for example.

I tried that rule set but didn't get things right.

Thanks
Regards

 

[dreid1011]

Maybe this to get you started, and you can add more columns/criteria to it with a new IF() statement for each new evaluation criteria.

Book1
	A	B	C	D
1	Organizational Skills	Communication Skills	Teamwork Skills	Overall Assessment
2	Yes	Yes	No	15%
Sheet1

Cell Formulas
Range	Formula
D2	D2	=SUM(IF(A2="Yes",0.05,0),IF(B2="Yes",0.1,0),IF(C2="Yes",0.1,0))

 

[AhoyNC]

Try:

Book2
	A	B	C	D							K	L
1	Organizational skills	Communication skills	Teamwork skills									overall assessment
2	yes	yes	no									15%
3	yes	yes	yes									30%
Sheet1

Cell Formulas
Range	Formula
L2:L3	L2	=SUM(IF($A2:$K2="yes",SEQUENCE(,COLUMNS($A$2:$K$2),5%,5%),0))

 

[6StringJazzer]

You need to put the % in another row. Then it's easy. I put it in row 3. Also your description did not match your screenshot, so I went with the screenshot.

$scratch.xlsm
	A	B	C	D
1	Organizational Skills	Communication Skills	Teamwork Skills	Overall Assessment
2	yes	yes	no
3	5%	10%	10%	15%
Skills

Cell Formulas
Range	Formula
D3	D3	=SUMPRODUCT(--($A$2:$C$2="yes"),$A$3:$C$3)

 

[bodew]

Thank you very much, guys.
You just have no idea how much you have helped me.
Once again, a huge thank you.

* Sorry for my bad English