Forum Discussion
Solved
Exam Scoring
Hello. I have a sheet with two tabs that we are using to score an examination. The Summary tab has all the examinations (Column A) and then Columns F - T are the scores based on the # of points missed, which vary by examination type.
On the Scoring tab, i would like to be able to enter the # of points missed, 2 for example in Scoring/B3 and then have a formula in Scoring C3 return the correct % from the Summary/Row 5. Summary/Row 5 because in Scoring B1 i am working on scoring the Daily Pump Check.
Here is a link to download the spreadsheet: https://www.dropbox.com/t/YMuw04L2qtlpTBCb
Thank you!
See the attached. I made some comments in the sheets to explain a bit better how it works. Among other things, I used named ranges of areas on the "Summary" tab, to make the single necessary formula, on the "Scoring" page, work and be legible.
Can you explain how we would arrive at 5 in D3?
And what should we look at for "305" and "Laying in"?
See the attached. I made some comments in the sheets to explain a bit better how it works. Among other things, I used named ranges of areas on the "Summary" tab, to make the single necessary formula, on the "Scoring" page, work and be legible.
- Thank you, this works perfectly. Much appreciated
