Scoring overview (raw scores, conversions, validity, clinical scales)
=SUM(IF(Scale_Key[Scale]="Hs", INDEX(Raw_Data!$B2:$BG2, Scale_Key[Item_Number]), 0)) mmpi2 excel better