AudyAnalyst
New Member
- Joined
- Nov 24, 2021
- Messages
- 20
- Office Version
- 365
- Platform
- Windows
Hello!
I'm trying to Sum related categories into one simplified category, However, I keep getting zero. Can you look at my formula and tell me where I'm going wrong? Thank you!
For Example, "a. Asian or Pacific Islander" should sum "Asian - Bangladeshi (United Kingdom)", "Asian - Chinese (France)", "Asian - Indian (United Kingdom)", Etc. Each group mapped to one of the Simplified can be found on the key. The sum should be within each location, Washington "WA", Oklahoma "OK", etc.
Please let me know if I need to provide more information.
I'm trying to Sum related categories into one simplified category, However, I keep getting zero. Can you look at my formula and tell me where I'm going wrong? Thank you!
For Example, "a. Asian or Pacific Islander" should sum "Asian - Bangladeshi (United Kingdom)", "Asian - Chinese (France)", "Asian - Indian (United Kingdom)", Etc. Each group mapped to one of the Simplified can be found on the key. The sum should be within each location, Washington "WA", Oklahoma "OK", etc.
Please let me know if I need to provide more information.
| Sum if Help.xlsm | |||
|---|---|---|---|
| E | |||
| 10 | |||
Key | |||
| Sum if Help.xlsm | |||
|---|---|---|---|
| H | |||
| 20 | |||
DATA | |||
| Race/Ethnicity | Global | WA | OK | FRAN | UK |
| White (United States of America) | 133 | 41 | 92 | 0 | 0 |
| White - British (United Kingdom) | 102 | 0 | 0 | 0 | 102 |
| White - Other (United Kingdom) | 21 | 0 | 0 | 0 | 21 |
| Mixed - Other (United Kingdom) | 1 | 0 | 0 | 0 | 1 |
| White - Other European (United Kingdom) | 21 | 0 | 0 | 0 | 21 |
| Asian - Chinese (France) | 2 | 0 | 0 | 2 | 0 |
| Asian (United States of America) | 69 | 17 | 52 | 0 | 0 |
| Asian - Indian (United Kingdom) | 5 | 0 | 0 | 0 | 5 |
| Asian - Other (France) | 25 | 0 | 0 | 25 | 0 |
| Not Declaring (United Kingdom) | 1 | 0 | 0 | 0 | 1 |
| Asian - Bangladeshi (United Kingdom) | 5 | 0 | 0 | 0 | 5 |
| Asian - Other (United Kingdom) | 3 | 0 | 0 | 0 | 3 |
| Two or More Races (United States of America) | 21 | 5 | 16 | 0 | 0 |
| Mixed - White & Asian (United Kingdom) | 13 | 0 | 0 | 0 | 13 |
| Mixed - White & Black Carribean (United Kingdom) | 1 | 0 | 0 | 0 | 1 |
| White (France) | 15 | 0 | 0 | 15 | 0 |
| I do not wish to answer. (United States of America) | 19 | 7 | 12 | 0 | 0 |
| Mixed - White & Black African (United Kingdom) | 2 | 0 | 0 | 0 | 2 |
| Asian - Pakistani (SP) (United Kingdom) | 7 | 0 | 0 | 0 | 7 |
| Asian - Chinese (United Kingdom) | 5 | 0 | 0 | 0 | 5 |
| Other (France) | 10 | 0 | 0 | 10 | 0 |
| Native Hawaiian or Other Pacific Islander (United States of America) | 3 | 1 | 2 | 0 | 0 |
| White - Irish (United Kingdom) | 11 | 0 | 0 | 0 | 11 |
| Black or African American (United States of America) | 20 | 17 | 3 | 0 | 0 |
| Middle Eastern or North African (United States of America) | 6 | 5 | 1 | 0 | 0 |
| Global | WA | OK | FRAN | UK | |
| a. Asian or Pacific Islander | 0 | =SUMIF(A2:A26,OR(Key!B2,Key!B3,Key!B4,Key!B5,Key!B6,Key!B7,Key!B8,Key!B9,Key!B10),DATA!C2:C26) | |||
| b. Black/African | 0 | ||||
| c. Hispanic or Latino | 0 | ||||
| d. Middle Eastern or North African | 0 | ||||
| f. Two or more races | 0 | ||||
| e. White | 0 | ||||
| Perfer Not to Say | 0 |
| Simplified | Race/Ethnicity on Survey |
| a. Asian or Pacific Islander | Asian - Bangladeshi (United Kingdom) |
| Asian - Chinese (France) | |
| Asian - Chinese (United Kingdom) | |
| Asian - Indian (United Kingdom) | |
| Asian - Other (France) | |
| Asian - Other (United Kingdom) | |
| Asian - Pakistani (SP) (United Kingdom) | |
| Asian (United States of America) | |
| Native Hawaiian or Other Pacific Islander (United States of America) | |
| b. Black/African | Black or African American (United States of America) |
| c. Hispanic or Latino | |
| d. Middle Eastern or North African | Middle Eastern or North African (United States of America) |
| f. Two or more races | Mixed - Other (United Kingdom) |
| Mixed - White & Asian (United Kingdom) | |
| Mixed - White & Black African (United Kingdom) | |
| Mixed - White & Black Carribean (United Kingdom) | |
| Other (France) | |
| Two or More Races (United States of America) | |
| e. White | White - British (United Kingdom) |
| White - Irish (United Kingdom) | |
| White - Other (United Kingdom) | |
| White - Other European (United Kingdom) | |
| White (France) | |
| White (United States of America) | |
| Perfer Not to Say | I do not wish to answer. (United States of America) |
| Not Declaring (United Kingdom) |
