Using SUMPRODUCT to find weighted averages

K

kjdeutin

So I am trying to complete this project and I have a question with usin
SUMPRODUCT and dropping the lowest test score. This is the formula I a
using:

=ROUND(SUMPRODUCT(B4:N4,$B$1:$N$1)/SUMPRODUCT($B$1:$N$1),0)

From B1:K1 there are different weights according to differen
assignments. From L1:N1 there are three exams worth 15% of my grade an
I'm trying to drop the lowest one. I am completely stuck and canno
figure this
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top