It is just a little bit difficult to understand (IMO only) how you are
unable to have blank fields.

Anyway, if you have figured out a way and it works for you, I guess
that is all that matters. The formula does not have to be "elegant" ...
if it works for you then so be it!!!


spooker4u Wrote:
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.


--
BenjieLop


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