Sum-obj
LabTalk Object Type:
The user should be aware that certain GUI operations may alter these values.
This script creates a range variable, then uses the sum() function to generate statistics on column B. The associated values are saved in sum object properties. These values are printed to the Script window.
range rr = [Book1]Sheet1!Col(B); col(C) = sum(rr); type "max = $(sum.max)"; // max value, col(b) type "mean = $(sum.mean)"; // mean value, col(b) type "min = $(sum.min)"; // min value, col(b) type "n = $(sum.n)"; // number of elements, col(b) type "sd = $(sum.sd)"; // // std. dev. , col(b) type "total = $(sum.total)"; //total, col(b) type "imax = $(sum.imax)"; // row index of max value, col(b) type "imin = $(sum.imin)"; // row index of min value, col(b)