How do I sum multiple columns using the formula window?

[#1]

I have a table with many columns and would like to easily sum a block of them (columns 50-100) in another column.  What is the best way to do so without making a formula: column50 + column51 + column52.... ?

I did find a similar question from 2015 showing you can shift+click to select many columns using the "Sum" function (https://community.jmp.com/t5/Discussions/How-do-I-sum-multiple-columns-using-the-formula-window/td-p...) but this did not work for me.  Instead, it would only insert the first column that was selected.  Not certain if it's because I'm on a Mac?

[#2 · Accepted solution]

At least on windows you can right click on the selected columns and select "Replace the selected subexpresssion with columns" (make sure the correct "square" is selected in the formula).

jthi_0-1698083796696.png

jthi_1-1698083838291.png

Edit:

You can also select your columns from the table, right click on one of the column headers and add formula column

jthi_2-1698083899647.png

jthi_3-1698083910300.png

[#3]

Thank you, Jarmo!!  This worked perfectly!!