Final Grade Formula

**skwiskwis** · 12-19-2010, 07:14 AM

Hello and thanks in advance - I've asked a number of formula questions here and members of this forum have been very generous with their help and time.

I have a grade sheet on excel which keep tracks of and averages different parts of the grades. The formulas are producing final averages now. To have excel compute the final grade, here is what I would like.

A formula that will compute the final grade based on:

The number in B63 is worth 15%
The number in B71 is worth 5%
The number in B88 is worth 10%
The number in B112 is worth 20%
The number in B153 is worth 25%
The number in B156 is worth 20%
The number in B157 is worth 5%

The formula will use the % for each cell and then compute the final grade.

**mrice** · 12-19-2010, 07:46 AM

Something like

=(B63*0.15)+(B71*0.05)+(B88*0.1)+(B112*0.2)+(B153*0.25)+(B156*0.2)+(B157*0.05)

?

**MarvinP** · 12-19-2010, 02:59 PM

Hi,

Your question brings more questions. What do you have in B63 and B71? Are these points or percents or averages?

Read first http://mathforum.org/library/drmath/view/57605.html
then http://office.microsoft.com/en-us/ex...in=HA010074091

**shg** · 12-19-2010, 03:17 PM

If you have a weight column (say, col A) that contains percentages totalling 100% in each of the grade rows and 0 in all other rows, then you can use

=sumproduct(a63:a157, b63:b157)