Before building any spreadsheet, you must understand what you are calculating. The MMPI-2 consists of 567 true/false items grouped into multiple scales:
=SUMPRODUCT((ScoringKey!B$2:B$568=1)*(RawData!C$2:C$568=ScoringKey!D$2:D$568)) mmpi-2 excel
Example Formula: =SUMPRODUCT((ItemResponses)*(ScoringKey!Scale1Range)) Before building any spreadsheet, you must understand what