Arte SheetsLearn. Try. Understand.

Healthcare & Clinical

IIEF-5 / SHIM: Adding Five Component Scores

Add five already-scored SHIM items while accounting for zero responses, questionnaire version and the limits of interpreting the total.

Five component scores in context

The five-item Sexual Health Inventory for Men (SHIM), also known as IIEF-5, was developed as a shorter measure of erectile function and satisfaction. This worksheet demonstrates addition of scores already assigned with an applicable questionnaire; it does not administer the questionnaire or diagnose erectile dysfunction.

In the version discussed in the cited methodological critique, the first item is scored from 1 to 5 and the four activity-dependent items can also have a zero response. Thus the arithmetic range is 1–25. The original 1999 diagnostic analysis reported results for scores 5–25. Apply the instructions for the actual instrument and version being used rather than treating these versions as interchangeable.

A zero response linked to no activity has to be interpreted in context. Opportunity, desire and whether activity was attempted affect what a low total means; absence of activity alone does not prove erectile dysfunction. The original study’s sensitivity and specificity describe its sample and cutoff, not a universal individual diagnosis.

Fictional five-component pointsArithmetic totalInterpretation
3, 3, 2, 3, 314Requires clinical context
1, 0, 0, 0, 01Includes zero responses; context matters
5, 5, 5, 5, 525Maximum arithmetic total

Sum five numeric whole-number scores

For this demonstration B2 accepts 1–5 and B3:B6 each accept 0–5. Blanks and text are not treated as a zero response. The result is a total only and is not a severity classification.

=IF(COUNT(B2:B6)<>5,"Missing or nonnumeric input",IF(OR(B2<1,B2>5,B3<0,B3>5,B4<0,B4>5,B5<0,B5>5,B6<0,B6>5,MOD(B2,1)<>0,MOD(B3,1)<>0,MOD(B4,1)<>0,MOD(B5,1)<>0,MOD(B6,1)<>0),"Invalid component score",SUM(B2:B6)))

Try the example

Use the original values or change them to test your understanding.

Further reading