How to add a new column and sum several columns

[IsaacRamiro]

Hello. I hope somebody can help me:

I am trying to sum several columns in my file, there is no formula to do it.

Best regards.

Ramiro.

[JarekSkudrzyk]

@IsaacRamiro hi,

the best way I know is to:
- use "transform" tool -  this way you will have values in one column and column names in the other

- then you can sum the column with values

- and then "Cross Tab" it back to the original form
Please let me know if this helps.

[HairyPotato]

Awesome and interesting article. Great things you’ve always shared with us. Thanks. Just continue composing this kind of post.

Dollar General Survey

[shaharsar]

Hi,

You can do so by using the Formula tool, just make sure all are numeric with Select or else.

Example in the attached screenshot.

Have a good day!

[grazitti_sapna]

Hi @IsaacRamiro ,

You can achieve this output in 2 ways:

1. Easiest way would be to use formula tool and sum the columns. 

2. Second is little bit lengthy but a good learning way to achieve the output.

I have attached the workflow for both, you can use any of them.

Thanks!!