Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Newbie Question
I can't figure out how to do something I think is simple.
I have a list of student names, and a list of test scores. Student Name Test#1 Test#2 etc.... GRADE Doe, Johnny Smith, Betty etc. B2 would be the score Johnny got on Test#1, etc. I want to calculate the grade for each student, using a formula for the test scores (it's not a simple sum). I can make the forumula, and get a grade by putting the formula in each cell at the end of the student row. But I have to put it in each cell, adding it each time I add a student, and changing the cell references. Isn't there a simple way to apply the same formula to a series of rows? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Newbie Question
Yes, there is.
If you can post your formula for row2 then we can advise you on how to change it to copy it down. Pete On Nov 7, 9:27 am, Ben Sharvy wrote: I can't figure out how to do something I think is simple. I have a list of student names, and a list of test scores. Student Name Test#1 Test#2 etc.... GRADE Doe, Johnny Smith, Betty etc. B2 would be the score Johnny got on Test#1, etc. I want to calculate the grade for each student, using a formula for the test scores (it's not a simple sum). I can make the forumula, and get a grade by putting the formula in each cell at the end of the student row. But I have to put it in each cell, adding it each time I add a student, and changing the cell references. Isn't there a simple way to apply the same formula to a series of rows? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Newbie Question
=SUM(B2,C2)/SUM(5/D2,5/E2)
Where columns B,C, D, E are scores in the columns. On Nov 7, 6:45 pm, Pete_UK wrote: Yes, there is. If you can post your formula for row2 then we can advise you on how to change it to copy it down. Pete On Nov 7, 9:27 am, Ben Sharvy wrote: I can't figure out how to do something I think is simple. I have a list of student names, and a list of test scores. Student Name Test#1 Test#2 etc.... GRADE Doe, Johnny Smith, Betty etc. B2 would be the score Johnny got on Test#1, etc. I want to calculate the grade for each student, using a formula for the test scores (it's not a simple sum). I can make the forumula, and get a grade by putting the formula in each cell at the end of the student row. But I have to put it in each cell, adding it each time I add a student, and changing the cell references. Isn't there a simple way to apply the same formula to a series of rows? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Newbie Question
Hi Ben,
You can just drag your formula down the sheet and the references will update automatically. Click on the cell that contains your formula and hover the cursor over the little box at the bottom right corner of the cell, your cursor will change to a small cross, just click and drag it down the sheet for say 10 cells then let go the left button and have a look at the result. If you don't see the little box in the corner (called the fill handle), then go to ToolsOptionsEdit Tab and check the box marked allow cell drag and drop. HTH Martin "Ben Sharvy" wrote in message oups.com... =SUM(B2,C2)/SUM(5/D2,5/E2) Where columns B,C, D, E are scores in the columns. On Nov 7, 6:45 pm, Pete_UK wrote: Yes, there is. If you can post your formula for row2 then we can advise you on how to change it to copy it down. Pete On Nov 7, 9:27 am, Ben Sharvy wrote: I can't figure out how to do something I think is simple. I have a list of student names, and a list of test scores. Student Name Test#1 Test#2 etc.... GRADE Doe, Johnny Smith, Betty etc. B2 would be the score Johnny got on Test#1, etc. I want to calculate the grade for each student, using a formula for the test scores (it's not a simple sum). I can make the forumula, and get a grade by putting the formula in each cell at the end of the student row. But I have to put it in each cell, adding it each time I add a student, and changing the cell references. Isn't there a simple way to apply the same formula to a series of rows? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Newbie Question
You may also wish to write your formula like this
=IF(B2="","",SUM(B2,C2)/SUM(5/D2,5/E2)) and drag it past the end of your data. The cell will stay blank until you enter data in column B A few similar options are =IF(AND(B2="",C2=""),"",SUM(B2,C2)/SUM(5/D2,5/E2)) this will stay blank until there is data in B and C =IF(COUNT(B2:E2)=4,"",SUM(B2,C2)/SUM(5/D2,5/E2)) this will stay blank until B C D and E have data in them. HTH Martin "MartinW" wrote in message ... Hi Ben, You can just drag your formula down the sheet and the references will update automatically. Click on the cell that contains your formula and hover the cursor over the little box at the bottom right corner of the cell, your cursor will change to a small cross, just click and drag it down the sheet for say 10 cells then let go the left button and have a look at the result. If you don't see the little box in the corner (called the fill handle), then go to ToolsOptionsEdit Tab and check the box marked allow cell drag and drop. HTH Martin "Ben Sharvy" wrote in message oups.com... =SUM(B2,C2)/SUM(5/D2,5/E2) Where columns B,C, D, E are scores in the columns. On Nov 7, 6:45 pm, Pete_UK wrote: Yes, there is. If you can post your formula for row2 then we can advise you on how to change it to copy it down. Pete On Nov 7, 9:27 am, Ben Sharvy wrote: I can't figure out how to do something I think is simple. I have a list of student names, and a list of test scores. Student Name Test#1 Test#2 etc.... GRADE Doe, Johnny Smith, Betty etc. B2 would be the score Johnny got on Test#1, etc. I want to calculate the grade for each student, using a formula for the test scores (it's not a simple sum). I can make the forumula, and get a grade by putting the formula in each cell at the end of the student row. But I have to put it in each cell, adding it each time I add a student, and changing the cell references. Isn't there a simple way to apply the same formula to a series of rows? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Newbie Question
Thank you for the help.
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Newbie Question
You're welcome Ben. Thanks for the feedback.
"Ben Sharvy" wrote in message oups.com... Thank you for the help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Real Newbie newbie question | New Users to Excel | |||
Newbie question: | Charts and Charting in Excel | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
Newbie With A Question | Excel Worksheet Functions | |||
Newbie question | New Users to Excel |