There are three solutions for this question:
1. You can use the "sum" function in your formula so that to calculate the sum of all columns through this worksheet:
Sum ([%h], 1, $(wks.ncols));
This formula can calculate the sum of all rows for all columns and saved into column
2. Use Descriptive Statistics
1) Select all the data you want to calculate, then select Statistics=>Descriptive Statistics=> Statistics on Rows=>Open Dialog
2) Check on Quantities to Compute=>Moments=>Sum is selected, then click OK, the results will be out put to a new column in this work sheet default.
3. Use Before Formula Scripts
1) Open Before Formula Scripts under the Set Values dialog
2) For example, if you want to calculate the sum on rows (from row j1 to row j2) from col(i1) to col(i2), you can type in code follows syntax below into Before Formula Scripts box:
rowstats irng:=col(i1)[j1]:col(i2)[j2] sum:=Col(m);
The results will be shown in Col (m)
Best regards,
Jason Zhao
OriginLab Tech Service
adding column values
Posted - 03/21/2014 : 11:38:23 PM
