Quote 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!!!!!!