Re: Excluding a cell from an average

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

IS this being calculated in the correct way, should you average the
percentage mark of each assignment, rather than summing the overall marks
and dividing by total assignment value.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"wmd" <wmd55ca@xxxxxxxxxxxxxx> wrote in message
news:RYzyg.170563$S61.68282@xxxxxxxxxxx
I'm working on creating a grade book, but I've encountered a problem
with excluding an assignment for individual students when averaging the
grades.

I have several different worksheets for different subjects. On each
sheet the students are listed on the left (A2:A26), the
assignments/quizzes are at the top (B1:Z1), and the value of each
assignment is at the bottom (B27:Z27).

I also have a "Results" page with the average mark (percent) for each
student, for each subject. The formula I've used on the "Results" page
is as follows (as an example):

=SUM(Sheet1!B2:Z2)/SUM(Sheet1!$B$27:$Z$27)

This all works fine. However, what I'm looking to do is have Excel
ignore a cell (and the corresponding assignment value) when computing
the percentage, IF an "X" is entered instead of a grade.

If I leave the cell blank, the percentage will calculate as if there was
a 0 grade in that cell; instead I want the program to essentially "skip"
that cell (and the assignment value) for that particular student when an
"X" is entered, and calculate the percentage properly.

Any suggestions?

Thanks in advance.

wmd


.

Relevant Pages

  • Re: So whats null then if its not nothing?
    ... Question mark. ... there is such an assignment for some entity then effectively all comparisons have to be avoided. ... myObject.addToAs(SomeVariable, "NormalValue") etc. ... Here we add this object to the specified axes with the specified concrete coordinate. ...
    (comp.databases.theory)
  • Excluding a cell from an average
    ... On each sheet the students are listed on the left, the assignments/quizzes are at the top, and the value of each assignment is at the bottom. ... However, what I'm looking to do is have Excel ignore a cell when computing the percentage, IF an "X" is entered instead of a grade. ...
    (microsoft.public.excel)
  • Re: Object with field that can be any type
    ... Mark wrote: ... possible assignment that could go in to "object." ... how to avoid using just "object". ... Though, even if that's what you meant (which would be odd, since it necessarily takes the discussion in the opposite direction the OP was intending), it's still not true, since the lack of strong typing is in fact a very clear and specific thing that is wrong with using "object". ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: recommendation on an exploit and malicious software
    ... Thank you for the suggestion, Luke, The requirement of the assignment is ... worm maybe the next assignment: ... Mark, I think Tuxkit is the one I am looing for, I will dig into it, thank ...
    (comp.os.linux.security)
  • Re: recommendation on an exploit and malicious software
    ... Thank you for the suggestion, Luke, The requirement of the assignment is ... worm maybe the next assignment: ... Mark, I think Tuxkit is the one I am looing for, I will dig into it, thank ...
    (comp.os.linux.security)