The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
Username:
 Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 how to sum in "set column values"		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

alvogel

Germany
5 Posts
Posted - 08/08/2010 :  3:15:37 PM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Ver. and Service Release (Select Help-->About Origin): 8
Operating System: vista

Dear Origin users,

how to sum up several colums into a new one? I have to sum 150 columns and dont want to write in the "set column value" Col(C1)+Col(C2)+Col(C3)+....+Col(C150).

Cheers,
alvogel

AmandaLu

439 Posts
Posted - 08/08/2010 :  11:45:47 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Dear alvogel,

To sum 150 continous columns using Set Column Values, you can use some scripts in the Before Fomula Scripts to define the dataset.

For example, to sum 9 continous columns from Col(A) to Col(I) in Book2, Sheet1, you can set the Set Column Values dialog as picture below:



Moreover, using Statistics on Row by selecting Statistics: Descriptive Statistics menu is also a convenient way to sum columns.
You can select just Sum in Qautities to Compute and specify <next to source> for Output Column.
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000