Scl 90 R Scoring Excel May 2026

=SUMIF(ItemKey[ItemNum], "SOM", INDEX(RawData!$B2:$CS2, MATCH(ItemKey[ItemNum], RawData!$B$1:$CS$1, 0))) But that’s complex for beginners. If you place item responses in B2:CS2 :

=ROUND(((SOM_sum / num_items_SOM) - mean) / SD * 10 + 50, 1) Example: scl 90 r scoring excel

Better: use named ranges or an item lookup table. Create a table in Scoring sheet: =SUMIF(ItemKey[ItemNum], "SOM", INDEX(RawData