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!

​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!  Read More

​