I need to make a formula for a gradebook. I have a row,
say "F" is the students name, and all their grades for
classwork, quizzes, and tests. The row above "E" is used
to determine what kind of grade they are getting...
classwork, quiz, or test. I already have row "F"
averaging into "F18" for the students grade, but the
problem I am having is that if "E22" is for Quiz, then I
need the grade in "F22" to be averaged twice for the final
grade. If it was to be a test then it would average three
times. I need help, I am hitting a brick wall.
THanks