Quote Originally Posted by daddylonglegs
OK, I see, formula would work except your percentages derived from VLOOKUP formula are text formatted, you can fix very easily by changing the , in SUMPRODUCT to a *, i.e.

=IF(C107,SUMPRODUCT(C93:C106*D93:D106)/C107,0)
Hmm i just tried the new formula and still no success. Have you tried it out in the attached spreadsheet and got it to work?