quote:

---

Originally posted by YimingChen

Try set column value with formula: total(col(A)[10*(i-1)+1:10*i])

James

---

n = int(wks.nrows/10);
range r2 = col(B);
for (int i = 1; i <= n; i++)
{
	range r1 = Col(A)[10*i-9:10*i];
	r2[i] = total(r1);
}

quote:

---

Originally posted by YimingChen

That is because your Origin version is too old. Try this way, go to menu Window->Script window. Paste the following script, highlight all and press enter key to run.

n = int(wks.nrows/10);
range r2 = col(B);
for (int i = 1; i <= n; i++)
{
	range r1 = Col(A)[10*i-9:10*i];
	r2[i] = total(r1);
}

James

---