topic Re: How do I sum multiple columns using the formula window? in Discussions

How do I sum multiple columns using the formula window?

tarpon17 — Thu, 21 May 2015 19:10:42 GMT

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

Re: How do I sum multiple columns using the formula window?

ms — Thu, 21 May 2015 20:34:58 GMT

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)`)));

Re: How do I sum multiple columns using the formula window?

Jeff_Perkinson — Tue, 18 Oct 2016 23:21:35 GMT

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

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.

-Jeff