Sep 12 2024 05:38 AM - edited Sep 12 2024 05:41 AM
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!
Sep 12 2024 07:25 AM
Solution
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.
Sep 12 2024 07:28 AM
Can you explain how we would arrive at 5 in D3?
And what should we look at for "305" and "Laying in"?
Sep 12 2024 07:25 AM
Solution
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.