Hi there,
Is there a formula/filter to sum values of different variables only if their cell value is equal to 1?
E.g.: I have four variables with categorical data from 1-3 indicating: 1= has an account, 2=has no account, 3=has deactivated account. I want to sum the "1s" of the four variables to compute a new variable indicating the number of accounts a respondent owns.
Many thanks in advance !
SUM IF function
Re: SUM IF function
Hi @flatliner,
in the screenshot there is a possible suggestion to get what you are looking for. Cheers,
Maurizio
in the screenshot there is a possible suggestion to get what you are looking for. Cheers,
Maurizio
Re: SUM IF function
Thanks Maurizio, that works perfectly fine!