1. ## Calculating Grades Using Excel (XP)

I teach college and use Excel to calculate my grades. I ended up writing long formulaes for each worksheet since different assignments count different amounts. I've attached a copy of one of my worksheets with the names blacked out. It is the beginning of the semester so not all the assignments have been turned in, thus the 70%. The formula for the first student's average is:

=((D5*\$D\$14)+(E5*\$E\$14)+(F5*\$F\$14))/\$C\$14

and they can get a lot longer in courses with more assignments. Is there some way to automate having Excel multiply the cells in one row (their grades) times the cells in another row (the percentages) and sum the results?

Ronny

2. ## Re: Calculating Grades Using Excel (XP)

Try this formula:

=SUMPRODUCT(D5:Z5,\$D\$14:\$Z\$14)/SUM(\$D\$14:\$Z\$14)

This one will calculate the weighted average of D5:Z5; blank cells and cells containing text are ignored. Replace column Z by the last column you expect to fill with grades.

3. ## Re: Calculating Grades Using Excel (XP)

This is soooooo much easier. Thanks.

Ronny

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•