How do I sum multiple columns using the formula window?

[#1]

I have a table with 100 or more columns and would like to easily sum them in another column.  Best way to do so without making a formula A + B + C.....100 times

[#2 · Accepted solution]

If a dynamic formula is not crucial, the jsl script below should add a new static column with the row-wise sum of every numeric column in the data table.

dt = Current Data Table();

dt << New Column("sum", numeric, values(V Sum((dt << get as matrix)`)));

[#3 · Accepted solution]

You can also do this within the formula editor using the Sum() function.

8819_Pasted_Image_5_21_15__5_13_PM.png

Fill in the argument for the function by clicking on the first column that you want to sum, and then shift-click on the last.

8820_Pasted_Image_5_21_15__5_07_PM.png

-Jeff