SUM IF function
Posted: Wed Jun 07, 2023 2:37 pm
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 !
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 !