Scl 90 R Scoring Excel 【Verified Source】

(Global Severity Index):

=SUMPRODUCT(--(ISNUMBER(MATCH(ItemNumbers, 1,4,12,27,40,42,48,49,52,53,56,58, 0))), Responses) scl 90 r scoring excel

PST = count of items where response ≥ 1 (not 0). otherwise use INDEX-MATCH with array formulas.)

=SUMIF(ItemKey[ItemNum], "SOM", INDEX(RawData!$B2:$CS2, MATCH(ItemKey[ItemNum], RawData!$B$1:$CS$1, 0))) scl 90 r scoring excel

(Note: Requires Excel 365 for multiple-criteria XLOOKUP; otherwise use INDEX-MATCH with array formulas.)