Choose 2 of 6 optional units for grade - formula question

X

xtrailer

I'm teaching a course that requires students to choose 2 of 6 units for a
value of 20% towards their course. My Excel sheet is set up so I can enter
the marks manually by units chosen, and each assignment is out of 100.
However, individual units do not have the same total points value.

How can I add up the points for each of the 2 optional units out of the
possible 6 and then calculate a value of 20%? Cells of units not chosen would
be left blank. Much appreciated!!
 
D

dan dungan

I'm not sure how units, assignments, marks differ in meaning, but it
seems you'd make a table on another sheet that holds the different
values for the units, then use vlookup to pull the correct amount.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to find out the grade from marks-functions 7
=MATCH with nested arrays assistance needed 0
Converting Text into Values 6
help with formula and multiple associated data sets 1
Calculating an inventory balance at a "point in time" 5
How to use VLookup with a range of numbers? 3
Need opinion on Project test questions and calculations 10
How do you set up your project to account for 6 of 8 hours a day.. 5

Top