try:
=sumproduct({quiz,hoemwork,tests},{0.1,0.15,0.75})



--
HTH

Regards
Sebation.G
"mjreisbord" ...
we created a spreadsheet for our kids grades, ie.

we show quiz 15%, homework 10% and tests 75%.

how do we average and weight the grade (and show the formulae) if there
were
no homework grades.

thanks,

mark reisbord