Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing up values
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing up values
For data in some row, say row #5, use:
=AVERAGE(5:5) No division is necessary and blank values are ignored. -- Gary''s Student - gsnu200812 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing up values
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(A6:D6)/SUM($A$3:$D$3) Format as a percentage, then copy down the rest of your scores. Hope this helps. Pete On Nov 9, 3:18*pm, Amin wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing up values
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" wrote: 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(A6:D6)/SUM($A$3:$D$3) Format as a percentage, then copy down the rest of your scores. Hope this helps. Pete On Nov 9, 3:18 pm, Amin wrote: 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing up values
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 On Nov 9, 4:29*pm, Amin wrote: 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" wrote: 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(A6:D6)/SUM($A$3:$D$3) Format as a percentage, then copy down the rest of your scores. Hope this helps. Pete On Nov 9, 3:18 pm, Amin wrote: 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- Hide quoted text - - Show quoted text - |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing up values
Hi,
This is a weighted average problem. One formula to solve this would be: =SUMPRODUCT($A$1:$D$1*A4:D4)/SUM($A$1:$D$1) Where the possible points are in A1:D1 and the actual scores for the first person are in A4:D4. Just copy this down and you will have everybodies weighted average. -- Thanks, Shane Devenshire "Amin" wrote: 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" wrote: 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(A6:D6)/SUM($A$3:$D$3) Format as a percentage, then copy down the rest of your scores. Hope this helps. Pete On Nov 9, 3:18 pm, Amin wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summing values within a value? | Excel Discussion (Misc queries) | |||
Finding Most Recent Values in Col1 -- Summing Matching Values | Excel Discussion (Misc queries) | |||
summing values in one row based on values in another row | Excel Worksheet Functions | |||
LOOKING FOR A NAME, THEN SUMMING ALL VALUES ASSOCIATED WITH NAME | Excel Discussion (Misc queries) | |||
searching for values and summing the corresponding values | Excel Worksheet Functions |