topic How do I Sum all rows in a single column in Discussions

How do I Sum all rows in a single column

Terri_Denver — Sat, 10 Jun 2023 23:30:46 GMT

I used JMP for many years, then did not for a few years and am back using JMP. The data I am working with is such that I need to be able to sum both rows and columns. Summing columns is easy for me using the formula function in column properties.

I have tried several of the suggestions about how to sum selected columns but I must be doing something wrong. All the values I have entered in the rows selected are removed when I apply the formula and row one shows a value of 0.

I am certain that this is operator error on my part. I could use some help figuring out how to sum all rows - or even selected rows - in a single column. I appreciate any help. Thanks Terri_Denver!

Instructions state to include JSL code - I don't know what that means.

Re: How do I Sum all rows in a single column

txnelson — Wed, 26 May 2021 19:53:18 GMT

I am a bit confused on what you are attempting to do. Would it be possible for you show a mockup of what you are trying to do?

Re: How do I Sum all rows in a single column

Jeff_Perkinson — Thu, 27 May 2021 01:37:06 GMT

Welcome back to using JMP, @Terri_Denver!

Like @txnelson, I'm a little confused about what you want to do but I wonder if you're thinking about a JMP data table like a spreadsheet. You should remember that . So, you can't create a formula in a single row or cell to create a summary of other rows.

Instead, if you just need to find the sum of a set of rows, use Tables->Summary or Tabulate to create table of your sums.