SOLVED

Exam Scoring

Copper Contributor

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!

3 Replies
best response confirmed by HansVogelaar (MVP)
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.

@DSpragueBFD 

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

 

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

Thank you, this works perfectly. Much appreciated
1 best response

Accepted Solutions
best response confirmed by HansVogelaar (MVP)
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.

View solution in original post