Summing up values

[Amin]

Hi i have this question asking me to to sum the values in tre row below the
scores and divide the by the total points but it's been difficult to solve it
because i can't figure which of the values here is the total points that
should be divided with. Note am summing all the values in a row before the
division, any ideas are wlcome

Chapter 9 Chapter 10 Chapter 11 Chapter 12
Points Points Points Points
100 100 100 50

Score Score Score Score
94 94 95 50
92 92 87 44

 

[Gary''s Student]

For data in some row, say row #5, use:

=AVERAGE(5:5)

No division is necessary and blank values are ignored.

 

[Pete_UK]

I think this means that you have 94 out of a possible 100, 94 out of
100, 95 out of 100 and 50 out of 50 on the first row of scores, then
92/100, 92/100,87/100 and 44/50 for your second row.

The total points available is given by:

=SUM($A$3:$D$3)

assuming this is on row 3, so if your first score row is row 6, then
put this in E6:

=SUM(A66)/SUM($A$3:$D$3)

Format as a percentage, then copy down the rest of your scores.

Hope this helps.

Pete

 

[Amin]

Hi Pete thanks for the help however when i tried this is what happened.
on the sheet actually. the quizzes % looks higher after using the formula
you sugested. here i've 100% on it. i know i will be summing all of it using
the SUMPRODUCT in the total column that makes me feel i sould not have any
higher percentages befroe the the total. i have provided a sample data from
the table and that of the rsults table below.

Component Percentage
table1
Homework Quizzes Exams Total Grade
Student 20% 40% 40% 100% Overall

Banks, 50% 100%
Benjamin, 48% 95%

Table2
Chapter 9 Chapter 10 Chapter 11 Chapter 12
Points Points Points Points
100 100 100 50
Student Score Score Score Score

Banks, 94 94 95 50
Benjamin, 92 92 87 44

 

[Pete_UK]

The total score for Banks is 333, which gives him/her 95% on the
quizzes (out of 360).

However, the quizzes only contribute 40% to the total mark, so you
have to factor that into it as well. It looks like Banks scored 50% on
homework, and as this is 20% overall, this means he gets 10% overall.
For quizzes, his 95% is equivalent to 38% overall. For exams, he got
100% and this is 40% overall. Thus his total adjusted mark is 10% +
38% + 40%, or 88%.

As I'm not sure anymore how your data is laid out, I can't really
advise you of an appropriate formula.

Hope this helps.

Pete

 

[ShaneDevenshire]

Hi,

This is a weighted average problem. One formula to solve this would be:

=SUMPRODUCT($A$1:$D$1*A44)/SUM($A$1:$D$1)

Where the possible points are in A11 and the actual scores for the first
person are in A44.

Just copy this down and you will have everybodies weighted average.