cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

Discussions

Solve problems, and share tips and tricks with other JMP users.
%3CLINGO-SUB%20id%3D%22lingo-sub-388551%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%EB%8B%A8%EC%9D%BC%20%EC%97%B4%EC%9D%98%20%EB%AA%A8%EB%93%A0%20%ED%96%89%EC%9D%84%20%ED%95%A9%EC%82%B0%ED%95%98%EB%8A%94%20%EB%B0%A9%EB%B2%95%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-388551%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%EB%AA%87%20%EB%85%84%20%EB%8F%99%EC%95%88%20JMP%EB%A5%BC%20%EC%82%AC%EC%9A%A9%ED%95%98%EB%8B%A4%EA%B0%80%20%EB%AA%87%20%EB%85%84%20%EB%8F%99%EC%95%88%20%EC%82%AC%EC%9A%A9%ED%95%98%EC%A7%80%20%EC%95%8A%EA%B3%A0%20%EB%8B%A4%EC%8B%9C%20JMP%EB%A5%BC%20%EC%82%AC%EC%9A%A9%ED%95%98%EA%B3%A0%20%EC%9E%88%EC%8A%B5%EB%8B%88%EB%8B%A4.%EB%82%B4%EA%B0%80%20%EC%9E%91%EC%97%85%ED%95%98%EA%B3%A0%20%EC%9E%88%EB%8A%94%20%EB%8D%B0%EC%9D%B4%ED%84%B0%EB%8A%94%20%ED%96%89%EA%B3%BC%20%EC%97%B4%EC%9D%84%20%EB%AA%A8%EB%91%90%20%ED%95%A9%EC%82%B0%ED%95%A0%20%EC%88%98%20%EC%9E%88%EC%96%B4%EC%95%BC%20%ED%95%A9%EB%8B%88%EB%8B%A4.%EC%97%B4%20%EC%86%8D%EC%84%B1%EC%97%90%EC%84%9C%20%EC%88%98%EC%8B%9D%20%ED%95%A8%EC%88%98%EB%A5%BC%20%EC%82%AC%EC%9A%A9%ED%95%98%EB%A9%B4%20%EC%97%B4%20%ED%95%A9%EA%B3%84%EB%A5%BC%20%EC%89%BD%EA%B2%8C%20%EA%B5%AC%ED%95%A0%20%EC%88%98%20%EC%9E%88%EC%8A%B5%EB%8B%88%EB%8B%A4.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%EC%84%A0%ED%83%9D%ED%95%9C%20%EC%97%B4%EC%9D%84%20%ED%95%A9%EC%82%B0%ED%95%98%EB%8A%94%20%EB%B0%A9%EB%B2%95%EC%97%90%20%EB%8C%80%ED%95%9C%20%EB%AA%87%20%EA%B0%80%EC%A7%80%20%EC%A0%9C%EC%95%88%EC%9D%84%20%EC%8B%9C%EB%8F%84%ED%96%88%EC%A7%80%EB%A7%8C%20%EB%AD%94%EA%B0%80%20%EC%9E%98%EB%AA%BB%ED%95%98%EA%B3%A0%20%EC%9E%88%EB%8A%94%20%EA%B2%83%20%EA%B0%99%EC%8A%B5%EB%8B%88%EB%8B%A4.%EC%88%98%EC%8B%9D%EC%9D%84%20%EC%A0%81%EC%9A%A9%ED%95%98%EB%A9%B4%20%EC%84%A0%ED%83%9D%ED%95%9C%20%ED%96%89%EC%97%90%20%EC%9E%85%EB%A0%A5%ED%95%9C%20%EB%AA%A8%EB%93%A0%20%EA%B0%92%EC%9D%B4%20%EC%A0%9C%EA%B1%B0%EB%90%98%EA%B3%A0%20%ED%96%89%201%EC%9D%98%20%EA%B0%92%EC%9D%B4%200%EC%9C%BC%EB%A1%9C%20%ED%91%9C%EC%8B%9C%EB%90%A9%EB%8B%88%EB%8B%A4.%3C%2FP%3E%3CP%3E%EB%82%98%EB%8A%94%20%EC%9D%B4%EA%B2%83%EC%9D%B4%20%EB%82%B4%20%EB%B6%80%EB%B6%84%EC%9D%98%20%EC%9A%B4%EC%98%81%EC%9E%90%20%EC%98%A4%EB%A5%98%EB%9D%BC%EA%B3%A0%20%ED%99%95%EC%8B%A0%ED%95%A9%EB%8B%88%EB%8B%A4.%EB%8B%A8%EC%9D%BC%20%EC%97%B4%EC%97%90%EC%84%9C%20%EB%AA%A8%EB%93%A0%20%ED%96%89%20%EB%98%90%EB%8A%94%20%EC%84%A0%ED%83%9D%ED%95%9C%20%ED%96%89%EC%9D%84%20%ED%95%A9%EC%82%B0%ED%95%98%EB%8A%94%20%EB%B0%A9%EB%B2%95%EC%9D%84%20%EC%95%8C%EC%95%84%EB%82%B4%EB%8A%94%20%EB%8D%B0%20%EB%8F%84%EC%9B%80%EC%9D%B4%20%EB%90%A0%20%EC%88%98%20%EC%9E%88%EC%8A%B5%EB%8B%88%EB%8B%A4.%EB%8F%84%EC%9B%80%EC%9D%84%20%EC%A3%BC%EC%85%94%EC%84%9C%20%EA%B0%90%EC%82%AC%ED%95%A9%EB%8B%88%EB%8B%A4.%20%EA%B3%A0%EB%A7%88%EC%9B%8C%20Terri_Denver!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJSL%20%EC%BD%94%EB%93%9C%EB%A5%BC%20%ED%8F%AC%ED%95%A8%ED%95%98%EB%9D%BC%EB%8A%94%20%EC%A7%80%EC%B9%A8%20%EC%83%81%ED%83%9C%20-%20%EA%B7%B8%EA%B2%8C%20%EB%AC%B4%EC%8A%A8%20%EB%9C%BB%EC%9D%B8%EC%A7%80%20%EB%AA%A8%EB%A5%B4%EA%B2%A0%EC%8A%B5%EB%8B%88%EB%8B%A4.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-388551%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CLINGO-LABEL%3E%EA%B3%A0%EA%B8%89%20%ED%86%B5%EA%B3%84%20%EB%AA%A8%EB%8D%B8%EB%A7%81%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3E%EC%9E%90%EB%8F%99%ED%99%94%20%EB%B0%8F%20%EC%8A%A4%ED%81%AC%EB%A6%BD%ED%8C%85%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3E%EC%86%8C%EB%B9%84%EC%9E%90%20%EB%B0%8F%20%EC%8B%9C%EC%9E%A5%20%EC%A1%B0%EC%82%AC%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3E%ED%92%88%EC%A7%88%20%EB%B0%8F%20%ED%94%84%EB%A1%9C%EC%84%B8%EC%8A%A4%20%EC%97%94%EC%A7%80%EB%8B%88%EC%96%B4%EB%A7%81%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-388622%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%EB%8B%A8%EC%9D%BC%20%EC%97%B4%EC%9D%98%20%EB%AA%A8%EB%93%A0%20%ED%96%89%EC%9D%84%20%ED%95%A9%EC%82%B0%ED%95%98%EB%A0%A4%EB%A9%B4%20%EC%96%B4%EB%96%BB%EA%B2%8C%20%ED%95%B4%EC%95%BC%20%ED%95%A9%EB%8B%88%EA%B9%8C%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-388622%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3EJMP%20%EC%82%AC%EC%9A%A9%EC%97%90%20%EB%8B%A4%EC%8B%9C%20%EC%98%A4%EC%8B%A0%20%EA%B2%83%EC%9D%84%20%ED%99%98%EC%98%81%ED%95%A9%EB%8B%88%EB%8B%A4.%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F28344%22%20target%3D%22_blank%22%3E%20%40Terri_Denver%3C%2FA%3E%20!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%EC%A2%8B%EB%8B%A4%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F2687%22%20target%3D%22_blank%22%3E%20%40txnelson%3C%2FA%3E%20%2C%20%EB%82%98%EB%8A%94%20%EB%8B%B9%EC%8B%A0%EC%9D%B4%20%EB%AC%B4%EC%97%87%EC%9D%84%20%ED%95%98%EA%B3%A0%20%EC%8B%B6%EC%9D%80%EC%A7%80%20%EC%A1%B0%EA%B8%88%20%ED%98%BC%EB%9E%80%EC%8A%A4%EB%9F%BD%EC%8A%B5%EB%8B%88%EB%8B%A4%EB%A7%8C%20%EC%8A%A4%ED%94%84%EB%A0%88%EB%93%9C%20%EC%8B%9C%ED%8A%B8%EC%99%80%20%EA%B0%99%EC%9D%80%20JMP%20%EB%8D%B0%EC%9D%B4%ED%84%B0%20%ED%85%8C%EC%9D%B4%EB%B8%94%EC%97%90%20%EB%8C%80%ED%95%B4%20%EC%83%9D%EA%B0%81%ED%95%98%EA%B3%A0%20%EC%9E%88%EB%8A%94%EC%A7%80%20%EA%B6%81%EA%B8%88%ED%95%A9%EB%8B%88%EB%8B%A4.%20%EB%8B%B9%EC%8B%A0%EC%9D%80%20%EA%B7%B8%EA%B2%83%EC%9D%84%20%EA%B8%B0%EC%96%B5%ED%95%B4%EC%95%BC%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2FDiscussions%2FJMP-is-Not-a-Spreadsheet%2Fm-p%2F214307%23U214307%22%20class%3D%22lia-mention-container-editor-message%20lia-img-icon-forum-thread%20lia-fa-icon%20lia-fa-forum%20lia-fa-thread%20lia-fa%22%20target%3D%22_blank%22%3E%20JMP%EB%8A%94%20%EC%8A%A4%ED%94%84%EB%A0%88%EB%93%9C%EC%8B%9C%ED%8A%B8%EA%B0%80%20%EC%95%84%EB%8B%99%EB%8B%88%EB%8B%A4.%3C%2FA%3E%20.%20%EB%94%B0%EB%9D%BC%EC%84%9C%20%EB%8B%A4%EB%A5%B8%20%ED%96%89%EC%9D%98%20%EC%9A%94%EC%95%BD%EC%9D%84%20%EB%A7%8C%EB%93%A4%EA%B8%B0%20%EC%9C%84%ED%95%B4%20%EB%8B%A8%EC%9D%BC%20%ED%96%89%EC%9D%B4%EB%82%98%20%EC%85%80%EC%97%90%20%EC%88%98%EC%8B%9D%EC%9D%84%20%EB%A7%8C%EB%93%A4%20%EC%88%98%20%EC%97%86%EC%8A%B5%EB%8B%88%EB%8B%A4.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%EB%8C%80%EC%8B%A0%20%ED%96%89%20%EC%A7%91%ED%95%A9%EC%9D%98%20%ED%95%A9%EA%B3%84%EB%A5%BC%20%EC%B0%BE%EC%95%84%EC%95%BC%20%ED%95%98%EB%8A%94%20%EA%B2%BD%EC%9A%B0%20%EB%8B%A4%EC%9D%8C%EC%9D%84%20%EC%82%AC%EC%9A%A9%ED%95%98%EC%8B%AD%EC%8B%9C%EC%98%A4.%3CA%20href%3D%22https%3A%2F%2Fwww.jmp.com%2Fsupport%2Fhelp%2Fen%2F16.0%2F%23page%2Fjmp%2Fsummarize-your-data.shtml%23186472%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3E%20%ED%85%8C%EC%9D%B4%EB%B8%94-%26gt%3B%EC%9A%94%EC%95%BD%3C%2FA%3E%20%EB%98%90%EB%8A%94%3CA%20href%3D%22https%3A%2F%2Fwww.jmp.com%2Fsupport%2Fhelp%2Fen%2F16.0%2F%23page%2Fjmp%2Ftabulate.shtml%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3E%20%ED%91%9C%EB%A1%9C%20%EB%A7%8C%EB%93%A4%EB%8B%A4%3C%2FA%3E%20%EA%B7%80%ED%95%98%EC%9D%98%20%ED%95%A9%EA%B3%84%20%ED%85%8C%EC%9D%B4%EB%B8%94%EC%9D%84%20%EB%A7%8C%EB%93%A4%20%EC%88%98%20%EC%9E%88%EC%8A%B5%EB%8B%88%EB%8B%A4.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-388584%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%EB%8B%A8%EC%9D%BC%20%EC%97%B4%EC%9D%98%20%EB%AA%A8%EB%93%A0%20%ED%96%89%EC%9D%84%20%ED%95%A9%EC%82%B0%ED%95%98%EB%A0%A4%EB%A9%B4%20%EC%96%B4%EB%96%BB%EA%B2%8C%20%ED%95%B4%EC%95%BC%20%ED%95%A9%EB%8B%88%EA%B9%8C%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-388584%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%EB%82%98%EB%8A%94%20%EB%8B%B9%EC%8B%A0%EC%9D%B4%ED%95%98%EB%A0%A4%EB%8A%94%20%EC%9D%BC%EC%97%90%20%EB%8C%80%ED%95%B4%20%EC%95%BD%EA%B0%84%20%ED%98%BC%EB%9E%80%20%EC%8A%A4%EB%9F%BD%EC%8A%B5%EB%8B%88%EB%8B%A4.%20%EB%8B%B9%EC%8B%A0%EC%9D%B4%ED%95%98%EB%A0%A4%EB%8A%94%20%EC%9D%BC%EC%9D%98%20%EB%AA%A8%ED%98%95%EC%9D%84%20%EB%B3%B4%EC%97%AC%EC%A4%84%20%EC%88%98%20%EC%9E%88%EC%8A%B5%EB%8B%88%EA%B9%8C%3F%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
Terri_Denver
Level I

How do I Sum all rows in a single column

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.

2 REPLIES 2
txnelson
Super User

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

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?
Jim
Jeff_Perkinson
Community Manager Community Manager

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

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 JMP is Not a Spreadsheet. 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. 

-Jeff

Recommended Articles