assigning different percentages to columns with yes response

[pd]

I have multiple boxes each with a yes or no response. If the data in the box
is "yes" the box is counted. I would like to write a formula that will allow
me to assign a different percentage value to each "yes" response. please see
the example below. Is this possible??? I have no problem claculating the
percentage if all are of equal value. I just can't seem to find a way to
calculate them with differing values.

INSTALLED DOOR HARDWARE

(POTENTIAL VALUES)
(25% 25% 35% 15% = 100%)

Lockset Closer Kick Plates Threshold % COMPLETE

YES YES YES NO 85%

 

[Gaurav]

Assuming that in A22 you have you percentage values and in A44 you have
your responses i.e. YES or NO. Enter the following formula in E4

=SUMIF(A44,"YES",A22)

Should work.