Arte SheetsLearn. Try. Understand.

Healthcare & Clinical Calculations

EPDS Screening: Checked Item Scoring and Safety Follow-up

Learn how to add pre-scored EPDS items while keeping a positive self-harm response visible even when other responses are missing.

A screening questionnaire, not a diagnosis

The Edinburgh Postnatal Depression Scale (EPDS), developed by Cox, Holden and Sagovsky, is a 10-item questionnaire about the past seven days. Each answer receives a score from 0 to 3; some response options are reverse scored. The total is a screening result, not a diagnosis, and the correct scoring key and clinical context matter.

The questionnaire does include a question about difficulty sleeping when unhappy. Thresholds and follow-up pathways vary by setting, so a low total should not be presented as proof of safety or absence of depression.

Respond to item 10 even with an incomplete total

A positive response to the self-harm item requires immediate further professional assessment, independently of the total score. COPE and NSW Health both emphasize this. If other answers are missing, they may prevent a total from being calculated, but must not hide an already recorded positive response.

The first formula below checks only a severity-coded item 10 value: 0 means no positive response recorded; 1–3 produce the assessment message. A blank or invalid item 10 is reported as missing, not treated as a negative response. This example is educational and is not a monitored safety system or a replacement for a clinical protocol.

=IF(COUNT(B11)<>1,"Item 10 missing or nonnumeric",IF(OR(B11<0,B11>3,MOD(B11,1)<>0),"Item 10 must be an integer from 0 to 3",IF(B11>0,"Positive item 10: immediate professional assessment","No positive item 10 recorded; full review still needed")))

Add the ten pre-scored items

The second formula requires all ten numeric whole-number scores in the range 0–3. The inputs are already severity-coded using the official scoring key; it does not convert selected answer positions or perform reverse scoring. In the demonstration, a missing item prevents a total, while a positive item 10 is still separately visible.

=IF(COUNT(B2:B11)<>10,"Enter all ten numeric item scores",IF(OR(MIN(B2:B11)<0,MAX(B2:B11)>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,MOD(B11,1)<>0),"Each item must be an integer from 0 to 3",SUM(B2:B11)))

Try the example

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

Further reading