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.