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%