Subscribe Bookmark RSS Feed

How do I sum multiple columns using the formula window?

tarpon17

Community Member

Joined:

May 21, 2015

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 SOLUTIONS

Accepted Solutions
ms

Super User

Joined:

Jun 23, 2011

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


Jeff_Perkinson

Community Manager

Joined:

Jun 23, 2011

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

-Jeff
2 REPLIES
ms

Super User

Joined:

Jun 23, 2011

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


Jeff_Perkinson

Community Manager

Joined:

Jun 23, 2011

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

-Jeff