On Jul 7, 12:53 pm, Pauline wrote:
Okay,
Column A Column B Column C Column D
Column E
Test Score Hour Points GPA Points Grade Points
Sum 0f A,B,C

45 10 40 45
95

How do I calculate a total score/grade with Column E worth 75% and Column A
worth 25%? Then once I have this answer rank them so that I will know who has
the highest score/grade

Does this help?

I thought I posted this, maybe two posts will show up eventually.

=A2*x+E2*3x

"x" can be anything, probably best to make it meaningful. For
instance, x=.30303 would give you a total of 100 if the numbers you
gave (45 and 95) are the maximum points available.

Regardless, take the number you've calculated as each student's score
and get grades as a percent of the maximum, of course.