I have a spreadsheet containing 150 workorders that were inspected based on 20 questions(columns). Each question has a specific numerical value and the only 3 possible answers are: PASS FAIL or N/A. I am trying to give points (lets say 30) for a pass or N/A, and 0 points for fail. Resulting in a final score displayed at the end of the row for each work order based on the 20 questions results. Any suggestions are very welcomed!