Origin Ver. and Service Release (Select Help-->About Origin): OriginPro 5.1.5 G Operating System: Windows 7, 64-bit
Hello together
I am new to Orgin and I would like to sum up the values highlighted in the graph.
How can I tell Origin that it has to check if the value in the coloumn is positive and if so that Origin shall built the sum of all positive values in that coloumn?
The sum value of the highlighted cells is always shown in the status bar at the bottom of the Origin window. If you want to put a condition, only when all cells are positive, you can run the following 4-line script in the Script window;
range rr=wcol(wks.c1)[wks.r1:wks.r2];
sum(rr);
if(sum.min>0) type All cells are positive (or missing). Sum is $(sum.total);
else type Some are negative or zero;
range rr = !A3[13:32]; //Specify the data range you want to sum double ss=0; loop (ii, 1, rr.getsize()) { If (rr[ii]>0) // If data is positive, add to the sum { ss = ss + rr[ii]; } } ss=; // Show the result in script window
If you don't want use script window, you can also implement this by set column values. Assume you have data in Col(A) and want put sum into col(D), see the screenshot below:
Sum up several values in one coloumn
Posted - 11/07/2013 : 06:25:32 AM
