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?