Origin Ver. and Service Release (Select Help-->About Origin): 8.0pro Operating System: vista
I wanna calculate the sum from row 3 to row 6 on the column A on the active work sheet. The follow code does not work,
int i1 = 3; int i2 = 6; range a = col(A)[$(i1):$(i2)]; sum(a) =
it will return on the Classic script window: SUM(a)=--
Thank you!
By the way, if I wanna calculate the sum from row 1 to the end on the column A on the active work sheet, how can I do this by mouse instead of writting code please?
sum(...) is a function to create various statistical properties like sum.N, sum.Total, sum.Mean, etc. (Try sum.=<ENTER> in Script window to see all properties.) Therefore the way like following should work:
int i1 = 3;
int i2 = 6;
range a = col(A)[$(i1):$(i2)];
sum(a);
mytotal=sum.total;
sum(...) is a function to create various statistical properties like sum.N, sum.Total, sum.Mean, etc. (Try sum.=<ENTER> in Script window to see all properties.) Therefore the way like following should work:
int i1 = 3;
int i2 = 6;
range a = col(A)[$(i1):$(i2)];
sum(a);
mytotal=sum.total;
--Hideo Fujii OriginLab
I restarted my Origin, in the first time that I tried your code, it returned "MYTOTAL=--". Then I changed to
range a2 = col(A)[$(i1):$(i2)]; sum(a2); mytotal=sum.total;
It returned the correct value.
Then I changed back by useing "a" for the range again. It returned the correct value again.
Although I was confused by its odd behavior, my question was finally solved. Thank you very much, Hideo!
sum over col(A)[3:6]
Posted - 10/06/2011 : 1:20:43 PM
