=SUM(B2,E2,M2,AB2,AN2,AP2,AV2,AW2,AZ2,BA2,BD2,BF2)
| Scale | ItemNum | |-----------|---------| | SOM | 1 | | SOM | 4 | | SOM | 12 | | ... | ... | | O-C | 3 | | etc. | | scl 90 r scoring excel
Then:
Better: use named ranges or an item lookup table. Create a table in Scoring sheet: scl 90 r scoring excel