Excel Magic Trick

Download Excel Start File: people.highline.edu/mgirvin/Y...
Download Excel Finished File: people.highline.edu/mgirvin/Y...
Full Page With All File Links: people.highline.edu/mgirvin/ex...
Use the SUM and VLOOKUP functions to create a Grade Book Based on Total Score and Weights Assigned to different Categories (Tests and Quizzes) that will calculate grade for you automatically.
VLOOKUP function information.
Formulas for Grades.
Excel Lookup Series

[@excelisfun]

I am glad that it helps!

[@excelisfun]

Do you know how to get the the excelisfun channel to see the latest videos released?

[@lynneanicole]

Thank you soooo much! You helped me a lot this evening!

[@excelisfun]

It is there I just posted it!

[@excelisfun]

If you download the workbook you can see the that there is a formula in the score column that is based on the total in Cell I13.
To see how to download the workbooks search for and watch this video title:
Search For Excel Videos Download Excel Files excelisfun

[@charlesnalong6511]

How can i email u. I have difficulties calculating Test Averages, Semester Average and Grade using Exam weights. I could send u a screen shot of the workbook im working on. At the moment I'm stuck. Need help asap

[@cubfix]

i was hoping to see your reply on the request i sent u said would be on monday.

[@excelisfun]

The title is:
Excel Magic Trick 415: Summarize Survey Results 2 Different Methods