CALC.countif(array, criteria)
CALC.binomdist(number_s, trials, probability_s, cumulative)
CALC.expondist(x, lambda, cumulative)
CALC.forecast(x, known_y_values, known_x_values)
CALC.frequency(data_array, bins_array)
CALC.hypgeomdist(sample_s, number_sample, population_s, number_population)
CALC.intercept(arrayY, arrayX)
CALC.negbinomdist(number_f, number_s, probability_s)
CALC.percentrank(array, x, significance)
CALC.permut(number, number_chosen)
CALC.poisson(x, mean, cumulative)
CALC.prob(arrayx, arrayprob, lower_limit, upper_limit)
CALC.rank(number, array, order)
CALC.rsq(known_y_values, known_x_values)
Counts the number of elements in the array that meet a certain criteria. The criteria can be a constant value '21' or an expression '>100'.
Example
CALC.countif([3,2,4,5,6], '> 4');
// returns 2
| << CALC.countn(array) | © 1996-2013 InetSoft Technology Corporation (v11.5) | CALC.covar(array1, array2) >> |