Hi,
I have a DOE setup where the names of the columns change. Is there a way to sum the values in column 1 and put them in Column "Total Volume" row 1, then sum column 2 and put them in "Total volume" row 2, etc? Thanks.
It is possible but it isn't really something you should do with JMP as JMP table isn't a spreadsheet(JMP is Not a Spreadsheet ). Below is example formula to give an idea how it could be done
If( Row() == 1, Col Sum(Column(1)), Row() == 2, Col Sum(Column(2)), . )
I think I may be misunderstanding what you want. But it sounds like using Table-Summary and asking for the sum of the relevant columns will give you what you want. You can then make it into a data table. If you need to have it placed in the original table with each row a different sum of columns, then you probably need to do something else.
Thank you this answered my question. And thanks for the link to JMP is not a spreadsheet. I've never seen this before and I do try to use JMP as a spreadsheet too often
