assigning different percentages to columns with yes response
 

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%

assigning different percentages to columns with yes response
 

Assuming that in A2:D2 you have you percentage values and in A4:D4 you have
your responses i.e. YES or NO. Enter the following formula in E4

=SUMIF(A4:D4,"YES",A2:D2)

Should work.


"pd" wrote in message
...
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%