Page 1 of 1

SUM IF function

Posted: Wed Jun 07, 2023 2:37 pm
by flatliner
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 !

Re: SUM IF function

Posted: Wed Jun 07, 2023 9:03 pm
by MAgojam
Hi @flatliner,
in the screenshot there is a possible suggestion to get what you are looking for.
ScreenShot_20230607225600.jpeg
ScreenShot_20230607225600.jpeg (150.16 KiB) Viewed 1602 times
Cheers,
Maurizio

Re: SUM IF function

Posted: Tue Jul 04, 2023 4:59 am
by flatliner
Thanks Maurizio, that works perfectly fine!