Well, I believe that I have figured it out (at least to the best of my
ability). I was unable to have blank fields, since every assignment
had a function assigned to it, so it was either 0 or whatever the
percentage the student's grade gave them.

Anyways, I copied my "final grade" worksheet into a new worksheet named
("Grades-Now!", then added a row above the table... I then manually
inputed number into this new row to use as its divisible average (i.e.
if I had 3 out of 4 test already taken, then I manually entered 3 into
that column for the function to only average the sum of the assignment
worksheet divided against the number that I manually inputed into the
column...

it seems to work alright now.

If this sounds confusing, I'm more than happy to provide a blank
spreadsheet to anyone who would like to use or see it.


--
spooker4u
------------------------------------------------------------------------
spooker4u's Profile: http://www.excelforum.com/member.php...o&userid=15935
View this thread: http://www.excelforum.com/showthread...hreadid=274155