Adding the number of columns that meet a criteria

[essemMLB]

Hello Alteryx community:

I have a set of 5 columns, each containing a value from 1 - 4. 

I would like to add a new column that sums the number of columns from the set of 5 IF the value in the column is 1. 

For example:

COLUMN A = 1

COLUMN B = 2

COLUMN C = 1

COLUMN D = 1

COLUMN E = 2

Would result in 

COLUMN F = 3

[JosephSerpis · Accepted solution]

Hi @essemMLB I mocked up a workflow let me know what you think? 

[essemMLB]

Works for me, thanks!