Hide #div/0 error

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)

Oh no its working now!

Cheers Sir

Ok, Last question.

In the summery the Percent Completed also shows some #DIV/0! and i cant use any formulas to get it to display 0.

any ideas?

In Summary G8 you have

=AVERAGE(G6:G7)

I wouldn't use any average formulas here, otherwise you are averaging averages which is mathematically unwise. Try using this formula in E6, replicated for all other rows including totals like G8

=IF(E6,F6/E6,0)

Originally Posted by daddylonglegs

In Summary G8 you have

=AVERAGE(G6:G7)

I wouldn't use any average formulas here, otherwise you are averaging averages which is mathematically unwise. Try using this formula in E6, replicated for all other rows including totals like G8

=IF(E6,F6/E6,0)

Cheers!!!!!!