Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Atlanta
    Posts
    568
    Thanks
    7
    Thanked 1 Time in 1 Post

    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
    Ronny Richardson

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    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. #3
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Atlanta
    Posts
    568
    Thanks
    7
    Thanked 1 Time in 1 Post

    Re: Calculating Grades Using Excel (XP)

    This is soooooo much easier. Thanks.

    Ronny
    Ronny Richardson

Posting Permissions

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