Healthcare & Clinical
GAD-7: Seven-Item Anxiety Symptom Score in a Spreadsheet
Sum seven fictional GAD-7 item scores with complete input checks, and understand the distinction between a screening score and a diagnosis.
What the seven-item score represents
GAD-7 is a seven-item measure of anxiety symptoms over the preceding two weeks. Each item uses a 0–3 frequency score, giving a total from 0 to 21. Scores of 5, 10 and 15 have been used as boundaries for mild, moderate and severe symptom levels in the original research.
A screening score is not a diagnosis and does not independently determine treatment or rule out a problem. In the original study, a score of 10 had sensitivity of 89% and specificity of 82% for generalized anxiety disorder; later systematic review estimates differed across settings. Screening accuracy should not be treated as a fixed individual probability.
| Total points | Common symptom-score description |
|---|---|
| 0–4 | Minimal symptom level |
| 5–9 | Mild symptom level |
| 10–14 | Moderate symptom level |
| 15–21 | Severe symptom level |
Sum seven fictional item scores
Enter all seven item scores as whole numbers from 0 to 3. This teaching example requires a complete set; some research or clinical protocols handle missing items differently, so use the relevant protocol rather than silently entering zero.
The formula returns the total only. A qualified professional must interpret a completed questionnaire in context; a number alone is not a diagnosis or a medication recommendation.
=IF(COUNT(B2:B8)<>7,"Enter all seven numeric scores",IF(OR(MIN(B2:B8)<0,MAX(B2:B8)>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),"Each score must be an integer from 0 to 3",SUM(B2:B8)))Try the example
Use the original values or change them to test your understanding.