need some help with MS Excel 2007
Hello! I am stuck. I'm trying to figure out mid-semester grades for my students without having to individually calculate each one. With Excel 2003 I could just highlight the cells in the "final grades" column and press ctrl+v to make one formula for one row work for the rest. That doesn't seem to be working.
Here's what I want to do:
Example Student A has 124 points for Assmt 1, 26 pts for Assmt 2, 85 pts for Assmt 3 and 76 pts for Assmt 4. There are a total of 380 points available at this time. I can get the sum of each column easily; it's dividing by the total points available that has got me riled up. The formula I've been able to use in the past is this: "=SUM(B2:K2)/380". That will not copy and paste into other cells; it only puts in another cell name to the formula for the cell it's copying from. What do I do so that I don't have to pull out my calculator every time I want to tell someone their midsemester grade?
Thanks for any and all help.
Here's what I want to do:
Example Student A has 124 points for Assmt 1, 26 pts for Assmt 2, 85 pts for Assmt 3 and 76 pts for Assmt 4. There are a total of 380 points available at this time. I can get the sum of each column easily; it's dividing by the total points available that has got me riled up. The formula I've been able to use in the past is this: "=SUM(B2:K2)/380". That will not copy and paste into other cells; it only puts in another cell name to the formula for the cell it's copying from. What do I do so that I don't have to pull out my calculator every time I want to tell someone their midsemester grade?
Thanks for any and all help.