Hi,

Assuming Points Awarded are in Row B and First Row of Data is Row C.

And Data is in Cols C, D, E, F and total in G.

The way Excel works you can just multiply each of the four entries in
the current row with the relevant entry in the first row. If the
current row entry is blank then the sum for that cell will be zero.

The formula will look like this:

=C3*$C$2+D3*$D$2+E3*$E$2+F3*$F$2

This can be copied down to subsequent rows.

Good Luck!

Peter Moran