Hi

The mathematical formula for weighted average is
Xaverage=SUM(Xi*Wi)/SUM(Wi)
where Xi and Wi are i's value and its weight respectively.

How the formual will look in Excel for your particular case, will depend on
how your data are organized ... is there a weight for every exam result in
separate column, or do you have some another column which allows to
calculate the weight for every entry, or is the case more complicated.


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"Gage Teacher" <Gage wrote in message
...
How do I weight a cell in an array of cells that I want to average?
Specifically, I want to give more weight to the final exam than to the
unit
tests. Sum and Sumproduct don't seem to apply.