Arte SheetsLearn. Try. Understand.

Healthcare & Clinical

PHQ-9: Symptom Points and a Separate Item 9 Check

Add nine already-scored PHQ-9 items and inspect item 9 separately, including when another response is missing or invalid.

A total score and an independent safety item

The PHQ-9 is a nine-item depression symptom measure. Each item is scored 0–3 for the preceding two weeks, and the complete total is 0–27. Common descriptive score ranges are 0–4, 5–9, 10–14, 15–19 and 20–27. A score is a screening or monitoring result, not a diagnosis by itself.

Item 9 is handled separately: any positive response requires follow-up by someone competent to assess suicide risk, even if the total score is low or cannot be calculated. A response of zero does not by itself rule out suicide risk; a missing or invalid response is not a negative response. Other clinical information and appropriate local safety procedures remain essential.

This spreadsheet demonstrates arithmetic with pre-scored values. It is not a monitored screening service, an emergency response system or a substitute for a clinical assessment. No alert generated by the workbook should be assumed to notify another person.

Hypothetical inputsTotal or item 9 resultPurpose
Nine complete item scores0–27 totalDescribes the sum
Item 9 = 1, 2 or 3Positive item 9Follow-up assessment needed even if another item is missing
Item 9 = 0Item 9 is zeroDoes not by itself exclude risk

Calculate the nine-item total

All nine cells B2:B10 must contain numeric whole-number scores from 0 to 3. Missing data are not counted as zero.

=IF(COUNT(B2:B10)<>9,"Missing or nonnumeric item",IF(OR(MIN(B2:B10)<0,MAX(B2:B10)>3,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,MOD(B9,1)<>0,MOD(B10,1)<>0),"Use whole item scores 0 to 3",SUM(B2:B10)))

Display the numerical score range

The bands describe the total, without automatically diagnosing depression or prescribing care.

=IF(COUNT(B2:B10)<>9,"Missing or nonnumeric item",IF(OR(MIN(B2:B10)<0,MAX(B2:B10)>3,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,MOD(B9,1)<>0,MOD(B10,1)<>0),"Use whole item scores 0 to 3",IF(SUM(B2:B10)<=4,"0 to 4",IF(SUM(B2:B10)<=9,"5 to 9",IF(SUM(B2:B10)<=14,"10 to 14",IF(SUM(B2:B10)<=19,"15 to 19","20 to 27"))))))

Check item 9 independently

This checks only B10 so a missing or invalid value in B2:B9 cannot hide a positive item 9. An absent or invalid B10 has its own explicit status.

=IF(COUNT(B10)<>1,"Item 9 missing or nonnumeric",IF(OR(B10<0,B10>3,MOD(B10,1)<>0),"Invalid item 9",IF(B10>0,"Item 9 positive: follow-up assessment","Item 9 = 0: risk not excluded")))

Try the example

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

Further reading