Forum Discussion

DSpragueBFD's avatar
DSpragueBFD
Copper Contributor
Sep 12, 2024
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 misse...
  • mathetes's avatar
    Sep 12, 2024

    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.

Resources