(SPSS - new variable) Combining

Hello everyone.

I have a social survey data set with 500 respondent answers. A question asks about social networks, where each respondent can name up to 10 relationships they have. Each relationship has it's own variable. A question asks does this person live in the same country as you? I would like to group all relations that live outside the country into one variable.

When I do frequencies for each variable and manually count, I see that there are 2,647 network members total. Of those, 196 live outside the country.

I have tried doing a COUNT, which strangely gives me 110 living outside the country and 500 total network members.

Doing a IF command into a new variable results in the same numbers (110 living outside the country and 500 total network members).

Any help would be greatly appreciated!