Exam Scoring

[DSpragueBFD]

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!

[#2 · Accepted solution]

@DSpragueBFD 

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.

[#3]

@DSpragueBFD 

Can you explain how we would arrive at 5 in D3?

And what should we look at for "305" and "Laying in"?

[#4]

Thank you, this works perfectly. Much appreciated