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 points | Arithmetic total | Interpretation |
|---|---|---|
| 3, 3, 2, 3, 3 | 14 | Requires clinical context |
| 1, 0, 0, 0, 0 | 1 | Includes zero responses; context matters |
| 5, 5, 5, 5, 5 | 25 | Maximum 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.