Healthcare & Clinical
IPSS / AUA-SI: Urinary Symptom Score and Subscores
Sum seven IPSS symptom points, see the numerical symptom band, and compare the commonly used storage and voiding subscores.
Seven symptom scores and a separate quality-of-life question
The AUA symptom index and the seven symptom questions of the IPSS summarize urinary symptoms over the previous month. Each symptom item is assigned a whole score from 0 to 5; their sum ranges from 0 to 35. A separate IPSS quality-of-life question is scored separately and is not included in this seven-item sum.
Commonly used symptom-score bands are 0–7, 8–19 and 20–35, often called mild, moderate and severe symptom ranges. They describe symptoms, not a diagnosis of benign prostatic hyperplasia (BPH), obstruction or another cause. The score alone does not dictate a medication, procedure or other treatment; clinical assessment and how much symptoms bother the person are also important.
One commonly used breakdown adds items 2, 4 and 7 for a storage subscore, and items 1, 3, 5 and 6 for a voiding subscore. These are summaries of the same seven points, not independent diagnoses. The example works with already assigned scores rather than administering the questionnaire.
| Illustrative score | Numerical band | Meaning |
|---|---|---|
| 0–7 | 0 to 7 | Mild symptom range |
| 8–19 | 8 to 19 | Moderate symptom range |
| 20–35 | 20 to 35 | Severe symptom range |
Total symptom score
Enter the seven numeric whole-number item scores in B2:B8. All seven are required, including when computing a subscore in this example.
=IF(COUNT(B2:B8)<>7,"Missing or nonnumeric input",IF(OR(MIN(B2:B8)<0,MAX(B2:B8)>5,MOD(B2,1)<>0,MOD(B3,1)<>0,MOD(B4,1)<>0,MOD(B5,1)<>0,MOD(B6,1)<>0,MOD(B7,1)<>0,MOD(B8,1)<>0),"Use whole item scores 0 to 5",SUM(B2:B8)))Numerical symptom band
The band describes the score and does not determine the cause of symptoms or a treatment plan.
=IF(COUNT(B2:B8)<>7,"Missing or nonnumeric input",IF(OR(MIN(B2:B8)<0,MAX(B2:B8)>5,MOD(B2,1)<>0,MOD(B3,1)<>0,MOD(B4,1)<>0,MOD(B5,1)<>0,MOD(B6,1)<>0,MOD(B7,1)<>0,MOD(B8,1)<>0),"Use whole item scores 0 to 5",IF(SUM(B2:B8)<=7,"0 to 7",IF(SUM(B2:B8)<=19,"8 to 19","20 to 35"))))Storage subscore (items 2, 4 and 7)
Sum frequency, urgency and nocturia item points.
=IF(COUNT(B2:B8)<>7,"Missing or nonnumeric input",IF(OR(MIN(B2:B8)<0,MAX(B2:B8)>5,MOD(B2,1)<>0,MOD(B3,1)<>0,MOD(B4,1)<>0,MOD(B5,1)<>0,MOD(B6,1)<>0,MOD(B7,1)<>0,MOD(B8,1)<>0),"Use whole item scores 0 to 5",B3+B5+B8))Voiding subscore (items 1, 3, 5 and 6)
Sum incomplete emptying, intermittency, weak stream and straining item points. Together the storage and voiding subtotals equal the seven-item total.
=IF(COUNT(B2:B8)<>7,"Missing or nonnumeric input",IF(OR(MIN(B2:B8)<0,MAX(B2:B8)>5,MOD(B2,1)<>0,MOD(B3,1)<>0,MOD(B4,1)<>0,MOD(B5,1)<>0,MOD(B6,1)<>0,MOD(B7,1)<>0,MOD(B8,1)<>0),"Use whole item scores 0 to 5",B2+B4+B6+B7))Try the example
Use the original values or change them to test your understanding.