Spreadsheet: 740159d1626203833-return-one-of-2-sums-based-on-a-cell-value-pardi-sample-workbook
Sheet: Lists, formulas, and values (2

Assessment Version | Info from | Pronouns | Response | Gender | Score |  |  |  |  |  |  |  | Question | Values
Parent/Caregiver (2-3) | Parent | he, him, his | Yes | Male | 0 |  |  |  |  |  |  |  | 10
Parent/Caregiver (4+) | Client | she, her, hers | No | Female | 1 |  |  |  |  |  |  |  | 11a
Child (age 8-13 years) | Medical Record | they, them, their | N/A | Non-Binary | 2 |  |  |  |  |  |  |  | 11b
Young person/Adult (14 years+) | Other | other: |  | Transgender | 3 |  |  |  |  |  |  |  | 12
 |  |  |  | other: | 4 |  |  |  |  |  |  |  | 13
 |  |  |  |  | 5 |  |  |  |  |  |  |  | 14
 |  |  |  |  | 6 |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  |  |  |  | 16a
 |  |  |  |  |  |  |  |  |  |  |  |  | 16b
 |  |  |  |  |  |  |  |  |  |  |  |  | 16c
 |  |  |  |  |  |  |  |  |  |  |  |  | 16d
 |  |  |  |  |  |  |  |  |  |  |  |  | 16e
 |  |  |  |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  |  | 18
 |  |  |  |  |  |  |  |  |  |  |  |  | 18a
 |  |  |  |  |  |  |  |  |  |  |  |  | 18b
 |  |  |  |  |  |  |  |  |  |  |  |  | 19
 |  |  |  |  |  |  |  |  |  |  |  |  | 19a
 |  |  |  |  |  |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  | 21
 |  |  |  |  |  |  |  |  |  |  |  |  | 22
 |  |  |  |  |  |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  |  |  |  |  |  | 24
 |  |  |  |  |  |  |  |  |  |  |  |  | 25
 |  |  |  |  |  |  |  |  |  |  |  |  | 26
 |  |  |  |  |  |  |  |  |  |  |  |  | 27
 |  |  |  |  |  |  |  |  |  |  |  |  | 28
 |  |  |  |  |  |  |  |  |  |  |  |  | PICA?
 |  |  |  |  |  |  |  |  |  |  |  |  | Severity
 |  |  |  |  |  |  |  |  |  |  |  |  | Current
 |  |  |  |  |  |  |  |  |  |  |  |  | Remission
 |  |  |  |  |  |  |  |  |  |  |  |  | Age
 |  |  |  |  |  |  |  |  |  |  |  |  | 29
 |  |  |  |  |  |  |  |  |  |  |  |  | 29a
 |  |  |  |  |  |  |  |  |  |  |  |  | 29b
 |  |  |  |  |  |  |  |  |  |  |  |  | 29c
 |  |  |  |  |  |  |  |  |  |  |  |  | 29d
 |  |  |  |  |  |  |  |  |  |  |  |  | 29e
 |  |  |  |  |  |  |  |  |  |  |  |  | 30
 |  |  |  |  |  |  |  |  |  |  |  |  | 31
 |  |  |  |  |  |  |  |  |  |  |  |  | 32
 |  |  |  |  |  |  |  |  |  |  |  |  | 33
 |  |  |  |  |  |  |  |  |  |  |  |  | 34
 |  |  |  |  |  |  |  |  |  |  |  |  | 35
 |  |  |  |  |  |  |  |  |  |  |  |  | 36
 |  |  |  |  |  |  |  |  |  |  |  |  | 37
 |  |  |  |  |  |  |  |  |  |  |  |  | 38
 |  |  |  |  |  |  |  |  |  |  |  |  | 39
 |  |  |  |  |  |  |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  |  |  |  |  |  | 41
 |  |  |  |  |  |  |  |  |  |  |  |  | 42
 |  |  |  |  |  |  |  |  |  |  |  |  | 43
 |  |  |  |  |  |  |  |  |  |  |  |  | 44
 |  |  |  |  |  |  |  |  |  |  |  |  | 45
 |  |  |  |  |  |  |  |  |  |  |  |  | 46
 |  |  |  |  |  |  |  |  |  |  |  |  | 47
 |  |  |  |  |  |  |  |  |  |  |  |  | 48
 |  |  |  |  |  |  |  |  |  |  |  |  | 49
 |  |  |  |  |  |  |  |  |  |  |  |  | 50
 |  |  |  |  |  |  |  |  |  |  |  |  | 51
 |  |  |  |  |  |  |  |  |  |  |  |  | 52
 |  |  |  |  |  |  |  |  |  |  |  |  | 53
 |  |  |  |  |  |  |  |  |  |  |  |  | 54
 |  |  |  |  |  |  |  |  |  |  |  |  | 55
 |  |  |  |  |  |  |  |  |  |  |  |  | 56
 |  |  |  |  |  |  |  |  |  |  |  |  | 57
 |  |  |  |  |  |  |  |  |  |  |  |  | 58
 |  |  |  |  |  |  |  |  |  |  |  |  | 59
 |  |  |  |  |  |  |  |  |  |  |  |  | Section
 |  |  |  |  |  |  |  |  |  |  |  |  | 60
 |  |  |  |  |  |  |  |  |  |  |  |  | 61
 |  |  |  |  |  |  |  |  |  |  |  |  | 62
 |  |  |  |  |  |  |  |  |  |  |  |  | 63
 |  |  |  |  |  |  |  |  |  |  |  |  | 64
 |  |  |  |  |  |  |  |  |  |  |  |  | 65
 |  |  |  |  |  |  |  |  |  |  |  |  | 66
 |  |  |  |  |  |  |  |  |  |  |  |  | 67
 |  |  |  |  |  |  |  |  |  |  |  |  | 68
 |  |  |  |  |  |  |  |  |  |  |  |  | 69
 |  |  |  |  |  |  |  |  |  |  |  |  | 70
 |  |  |  |  |  |  |  |  |  |  |  |  | Section
 |  |  |  |  |  |  |  |  |  |  |  |  | 71a
 |  |  |  |  |  |  |  |  |  |  |  |  | 71b
 |  |  |  |  |  |  |  |  |  |  |  |  | 72a
 |  |  |  |  |  |  |  |  |  |  |  |  | 72b
 |  |  |  |  |  |  |  |  |  |  |  |  | 73a
 |  |  |  |  |  |  |  |  |  |  |  |  | 73b
 |  |  |  |  |  |  |  |  |  |  |  |  | 74a
 |  |  |  |  |  |  |  |  |  |  |  |  | 74b
 |  |  |  |  |  |  |  |  |  |  |  |  | 75
 |  |  |  |  |  |  |  |  |  |  |  |  | 76
 |  |  |  |  |  |  |  |  |  |  |  |  | 77
 |  |  |  |  |  |  |  |  |  |  |  |  | 78
 |  |  |  |  |  |  |  |  |  |  |  |  | 79
 |  |  |  |  |  |  |  |  |  |  |  |  | 80
 |  |  |  |  |  |  |  |  |  |  |  |  | section
 |  |  |  |  |  |  |  |  |  |  |  |  | 81
 |  |  |  |  |  |  |  |  |  |  |  |  | 82
 |  |  |  |  |  |  |  |  |  |  |  |  | 83
 |  |  |  |  |  |  |  |  |  |  |  |  | ARFID?
 |  |  |  |  |  |  |  |  |  |  |  |  | true 1
 |  |  |  |  |  |  |  |  |  |  |  |  | true 2
 |  |  |  |  |  |  |  |  |  |  |  |  | true 3
 |  |  |  |  |  |  |  |  |  |  |  |  | true 4
 |  |  |  |  |  |  |  |  |  |  |  |  | Sensory
 |  |  |  |  |  |  |  |  |  |  |  |  | Interest
 |  |  |  |  |  |  |  |  |  |  |  |  | Fear
 |  |  |  |  |  |  |  |  |  |  |  |  | Severity
 |  |  |  |  |  |  |  |  |  |  |  |  | Age
 |  |  |  |  |  |  |  |  |  |  |  |  | 83
 |  |  |  |  |  |  |  |  |  |  |  |  | 84
 |  |  |  |  |  |  |  |  |  |  |  |  | 85
 |  |  |  |  |  |  |  |  |  |  |  |  | 86
 |  |  |  |  |  |  |  |  |  |  |  |  | 87
 |  |  |  |  |  |  |  |  |  |  |  |  | 88
 |  |  |  |  |  |  |  |  |  |  |  |  | 89
 |  |  |  |  |  |  |  |  |  |  |  |  | 90
 |  |  |  |  |  |  |  |  |  |  |  |  | 91
 |  |  |  |  |  |  |  |  |  |  |  |  | 92a
 |  |  |  |  |  |  |  |  |  |  |  |  | 92b
 |  |  |  |  |  |  |  |  |  |  |  |  | 92c
 |  |  |  |  |  |  |  |  |  |  |  |  | 93
 |  |  |  |  |  |  |  |  |  |  |  |  | 93a
 |  |  |  |  |  |  |  |  |  |  |  |  | 93b
 |  |  |  |  |  |  |  |  |  |  |  |  | 93c
 |  |  |  |  |  |  |  |  |  |  |  |  | 94
 |  |  |  |  |  |  |  |  |  |  |  |  | 95
 |  |  |  |  |  |  |  |  |  |  |  |  | 96
 |  |  |  |  |  |  |  |  |  |  |  |  | 97
 |  |  |  |  |  |  |  |  |  |  |  |  | 98
 |  |  |  |  |  |  |  |  |  |  |  |  | 99
 |  |  |  |  |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  |  |  |  |  | Rumination?
 |  |  |  |  |  |  |  |  |  |  |  |  | Severity
 |  |  |  |  |  |  |  |  |  |  |  |  | Current
 |  |  |  |  |  |  |  |  |  |  |  |  | Remission
 |  |  |  |  |  |  |  |  |  |  |  |  | Age