=SUM(RawData!B2, RawData!E2, RawData!M2, RawData!AB2, RawData!AN2, RawData!AP2, RawData!AV2, RawData!AW2, RawData!AZ2, RawData!BA2, RawData!BD2, RawData!BF2) (adjust columns as per your layout)
=ROUND(((SOM_sum / num_items_SOM) - mean) / SD * 10 + 50, 1) Example:
Then for SOM (items 1,4,12…):
=SUM(B2,E2,M2,AB2,AN2,AP2,AV2,AW2,AZ2,BA2,BD2,BF2)
For SOM (12 items):
