Calculation weighted averages in excel 2010

[lgktillett]

I need help with a formula for weighted averages. I have tried different variations but can't get it to work:
=SUMPRODUCT($B$6:$B$9,$B$16:$E$45/SUM(B16:E16))

The percentages are contstant and are in B6-B9.

The grades are in B16-E45, with the formula in column F.

If you need more info to help, just let me know...Thank you.

 

[jeffreybrown]

Hello I welcome to the board,

I don't think this will work as sumproduct requires identical ranges.

At little more info is required. What are you trying to accomplish?

In my sig you will find an HTML where you can post a sample of your data.

 

[lgktillett]

I guess I'm not as computer savvy as I thought...I can't get the link to open correctly so here is the table:

<TABLE style="WIDTH: 405pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=540><COLGROUP><COL style="WIDTH: 104pt; mso-width-source: userset; mso-width-alt: 5046" width=138><COL style="WIDTH: 77pt; mso-width-source: userset; mso-width-alt: 3730" width=102><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2742" span=4 width=75><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4 0.5pt solid; BACKGROUND-COLOR: #c4d79b; WIDTH: 104pt; HEIGHT: 15pt; BORDER-TOP: #b8cce4 0.5pt solid; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl72 height=20 width=138>Marking Period</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: #c4d79b; WIDTH: 77pt; BORDER-TOP: #b8cce4 0.5pt solid; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl73 width=102>Weight</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: #c4d79b; WIDTH: 56pt; BORDER-TOP: #b8cce4 0.5pt solid; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl73 width=75>Median</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: #c4d79b; WIDTH: 56pt; BORDER-TOP: #b8cce4 0.5pt solid; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl73 width=75>Maximum</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: #c4d79b; WIDTH: 56pt; BORDER-TOP: #b8cce4 0.5pt solid; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl73 width=75>Minimum</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: #c4d79b; WIDTH: 56pt; BORDER-TOP: #b8cce4 0.5pt solid; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl73 width=75>Range</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #b8cce4; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl66 height=20>MP 1</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: transparent; BORDER-TOP: #b8cce4; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl67 align=right>15%</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: transparent; BORDER-TOP: #b8cce4; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl69></TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: transparent; BORDER-TOP: #b8cce4; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl69></TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: transparent; BORDER-TOP: #b8cce4; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl69></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #b8cce4; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl66 height=20>MP 2</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: transparent; BORDER-TOP: #b8cce4; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl67 align=right>20%</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: transparent; BORDER-TOP: #b8cce4; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl69></TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: transparent; BORDER-TOP: #b8cce4; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl69></TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: transparent; BORDER-TOP: #b8cce4; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl69></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #b8cce4; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl66 height=20>MP 3</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: transparent; BORDER-TOP: #b8cce4; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl67 align=right>25%</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: transparent; BORDER-TOP: #b8cce4; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl69></TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: transparent; BORDER-TOP: #b8cce4; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl69></TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: transparent; BORDER-TOP: #b8cce4; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl69></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #b8cce4; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl66 height=20>Final Exam</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: transparent; BORDER-TOP: #b8cce4; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl67 align=right>40%</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: transparent; BORDER-TOP: #b8cce4; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl69></TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: transparent; BORDER-TOP: #b8cce4; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl69></TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: transparent; BORDER-TOP: #b8cce4; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl69></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=20>Final Grades</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4 0.5pt solid; BACKGROUND-COLOR: #ebf1de; BORDER-TOP: #b8cce4; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl68 align=right>100%</TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: #ebf1de; BORDER-TOP: #b8cce4; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70></TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: #ebf1de; BORDER-TOP: #b8cce4; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70></TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: #ebf1de; BORDER-TOP: #b8cce4; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70></TD><TD style="BORDER-BOTTOM: #b8cce4 0.5pt solid; BORDER-LEFT: #b8cce4; BACKGROUND-COLOR: #ebf1de; BORDER-TOP: #b8cce4 0.5pt solid; BORDER-RIGHT: #b8cce4 0.5pt solid" class=xl70></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=20></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=20></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #daeef3; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>Students</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl64></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=20></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl63 height=20>Student Grades</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffc7ce; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl78 colSpan=2>Top 15 Final Grades</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8 0.5pt solid; BACKGROUND-COLOR: #c4d79b; HEIGHT: 15pt; BORDER-TOP: #b7dee8 0.5pt solid; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl76 height=20>Student Name</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: #c4d79b; BORDER-TOP: #b7dee8 0.5pt solid; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl74>MP 1</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: #c4d79b; BORDER-TOP: #b7dee8 0.5pt solid; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl74>MP 2</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: #c4d79b; BORDER-TOP: #b7dee8 0.5pt solid; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl74>MP 3</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: #c4d79b; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl75>Final Exam</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: #c4d79b; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl75>Final Grades</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8 0.5pt solid; BACKGROUND-COLOR: #fabf8f; HEIGHT: 15pt; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 height=20>Albert Barns</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl71 align=right>98.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl71 align=right>83.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl71 align=right>79.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl71 align=right>72.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl71 align=middle>#VALUE!</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8 0.5pt solid; BACKGROUND-COLOR: #fabf8f; HEIGHT: 15pt; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 height=20>Brooklyn Rodriguez</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl71 align=right>84.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl71 align=right>87.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl71 align=right>94.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl71 align=right>80.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl71></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8 0.5pt solid; BACKGROUND-COLOR: #fabf8f; HEIGHT: 15pt; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 height=20>Grace Kellian</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl71 align=right>55.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl71 align=right>56.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl71 align=right>63.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl71 align=right>65.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl71></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8 0.5pt solid; BACKGROUND-COLOR: #fabf8f; HEIGHT: 15pt; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl77 height=20>Sophie Tuckman</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl71 align=right>95.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl71 align=right>91.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl71 align=right>93.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl71 align=right>94.0</TD><TD style="BORDER-BOTTOM: #b7dee8 0.5pt solid; BORDER-LEFT: #b7dee8; BACKGROUND-COLOR: transparent; BORDER-TOP: #b7dee8; BORDER-RIGHT: #b7dee8 0.5pt solid" class=xl71></TD></TR></TBODY></TABLE>

 

[jeffreybrown]

Not so sure I know how to do this in your format, but I'll keep trying.

In the meantime, how about the below with F10 as =SUMPRODUCT(B10:E10,$B$9:$E$9)

<TABLE style="WIDTH: 381pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=504 border=0><COLGROUP><COL style="WIDTH: 86pt; mso-width-source: userset; mso-width-alt: 4169" width=114><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2852" span=5 width=78><TBODY><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 86pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=114 height=20>Student Name

</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 59pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=78>MP 1</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 59pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=78>MP 2</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 59pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=78>MP 3</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 59pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=78>Final Exam</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 59pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=78>Final Grades</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>Percent</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 59pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=78>15%</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 59pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=78>20%</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 59pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=78>25%</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 59pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=78>40%</TD><TD class=xl69 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">100%</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 86pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=114 height=20>Albert Barns</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 59pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=78>98</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 59pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=78>83</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 59pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=78>79</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 59pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=78>72</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 59pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=78>79.85</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 86pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=114 height=20>Brooklyn Rodriguez</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 59pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=78>84</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 59pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=78>87</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 59pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=78>94</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 59pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=78>80</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 59pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=78>85.5</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 86pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=114 height=20>Grace Kellian</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 59pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=78>55</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 59pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=78>56</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 59pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=78>63</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 59pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=78>65</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 59pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=78>61.2</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 86pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=114 height=20>Sophie Tuckman</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 59pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=78>95</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 59pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=78>91</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 59pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=78>93</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 59pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=78>94</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; WIDTH: 59pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent" width=78>93.3

<!-- / message --></TD></TR></TBODY></TABLE>

 

[lgktillett]

Is this what you need???

Excel Workbook
	A	B	C	D	E	F
5	Marking Period	Weight	Median	Maximum	Minimum	Range
6	MP 1	15%
7	MP 2	20%
8	MP 3	25%
9	Final Exam	40%
10	Final Grades	100%
11
12					Students
13
14	Student Grades				Top 15 Final Grades
15	Student Name	MP 1	MP 2	MP 3	Final Exam	Final Grades
16	John Jones	98.0	83.0	79.0	72.0	#VALUE!
17	Shawn Michaels	84.0	87.0	94.0	80.0
18	Sue Lennon	55.0	56.0	63.0	65.0
19	Tom Kramer	95.0	91.0	93.0	94.0
20	Lisa Smith	83.0	82.0	76.0	77.0
Final Grades

Excel 2010

Cell Formulas
Range	Formula
B10	=SUM(B6:B9)
F16	=AVERAGE($B$6:$B$9,$B$16:$E$16/SUM(B16:E16))

 

[doublej_jj]

I agree you need more information: If your grades are in B16 to B45, you need to know the weight of each grade, say C16 to C45. If you had that information you could do =sumproduct((B16:B45)*(C16:C45))

If you are implying that there are "categories" for 4 assignment types, then all the scores for each type should be subtotals beside your weights and the sumproduct applied to those four rows.

Hope that helped some.

 

[West Man]

Assuming the weights are in B2:B5 and the test scores are in B12:E12, try:
=SUM(TRANSPOSE($B$2:$B$5)*(B12:E12)) confirmed with Ctrl Shift Enter

 

[lgktillett]

Thank you..West Man...it worked. You are a life saver!!!

 

[West Man]

Glad to be of help