SUMIF: how to get the conditional sum across columns?
I want to calculate the sum of 10 columns into a new column, whereby I only want to sum the positive values. Similarly, I want another column summing all negative values. In Excel I would use the function SUMIF: =SUMIF(A1:J1;">0")How can I do something similar in JMP?Using a simple example in excel (while obviously my dataset is a bigger), this is what I am aiming for: ABCDpositive sumnegati...