View Single Post
  #4   Report Post  
Jerry W. Lewis
 
Posts: n/a
Default

wrote:

....

Assume that A1:A5 has the values above, and B1:B5 has
the respective scores. Then the average score (C1) is:

=SUMPRODUCT(A1:A5,B1:B5)/(SUM(A1:A5)-1)


I think you meant

=SUMPRODUCT(A1:A5,B1:B5)/SUM(A1:A5)

Jerry