You have to fix the formulas at the bottom of the page. Make sure the Range
includes all you student rows. If you Insert in the middle of the student
data the Rows of these formulas should automatically increase. You just need
to copy the formulas in columns D, E, and F on the individual rows. I
usuallly copy the entire row and then Insert copy Row, rather than insert row
and then have to copy the formulas.

Average Column D
=IF(SUM(D13:D52),AVERAGE(D13:D52),"")
Average Column E
=IF(D55<"",HLOOKUP(D55,GradeTable,2),"")
Average Column F
=IF(SUM(F13:F52),AVERAGE(F13:F52),"")

Highest Column D
=IF(SUM(D13:D52),MAX(D13:D52),"")
Highest Column E
=IF(D56<"",HLOOKUP(D56,GradeTable,2),"")
Highest Column F
=IF(SUM(F13:F52),MAX(F13:F52),"")

Lowest Column D
=IF(SUM(D13:D52),MIN(D13:D52),"")
Lowest Column E
=IF(D57<"",HLOOKUP(D57,GradeTable,2),"")
Lowest Column F
=IF(SUM(F13:F52),MIN(F13:F52),"")

"Rick" wrote:

I was wrong.
When I past the formula and enter the new data everything is fine.
But when I click the save button, the data stays in the fields, but the
calculated columns for Average, Ltr Grade, and GPA disappear.

Am I doing something wrong?

"Peo Sjoblom" wrote:

Did I say that?

--


Regards,


Peo Sjoblom

"Joel" wrote in message
...
Why wouldn't people download files from a trusted microsoft webpage????

"Peo Sjoblom" wrote:

Well since many of the regulars probably won't go to MS download site and
download this
file maybe you can explain what formulas (I assume it is a lookup
formula)
you are using and what does not work?
First thing I would check is if the new student's numbers are in fact
text.

--


Regards,


Peo Sjoblom

"Rick" wrote in message
...
I use a grade book which I downloaded from the Microsoft site. It works
great, except when I had to add a new student. The grades do not
calculate
like in the other rows of students. I tried changing the grades of the
other students to make sure it is calculating correctly, and it does.
It
is
only for this new student. I also tried entering the grade directly in
the
row, and then into the formula bar, all to no avail.
Any ideas?