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

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

Spooker,

I guess I should have given you some other alternatives then. If your
grades are in A2:G2, for example, enter this then copy down to match your
other students' grades:

=SUMIF(A2:G2,"0")/COUNTIF(A2:G2,"0")

or, array entered (entered with Ctrl-Shift-Enter)
=AVERAGE(IF(A2:G20,A2:G2))

HTH,
Bernie
MS Excel MVP


"spooker4u" wrote in message
...

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