SUM IF function

General help and assistance with jamovi. Bug reports can be made at our issues page: https://github.com/jamovi/jamovi/issues . (If you're unsure feel free to discuss it here)
Post Reply
flatliner
Posts: 6
Joined: Sun Feb 26, 2023 2:18 pm

SUM IF function

Post 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 !
User avatar
MAgojam
Posts: 421
Joined: Thu Jun 08, 2017 2:33 pm
Location: Parma (Italy)

Re: SUM IF function

Post 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 1221 times
Cheers,
Maurizio
flatliner
Posts: 6
Joined: Sun Feb 26, 2023 2:18 pm

Re: SUM IF function

Post by flatliner »

Thanks Maurizio, that works perfectly fine!
Post Reply