cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
tarpon17
Level I

How do I sum multiple columns using the formula window?

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 (Alumni) ms
Super User (Alumni)

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

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


View solution in original post

Jeff_Perkinson
Community Manager Community Manager

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

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

View solution in original post

2 REPLIES 2
ms
Super User (Alumni) ms
Super User (Alumni)

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

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 Community Manager

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

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