Juniper Systems Allegro CX Manual - Manual (Page 165)

Allegro CX Owner’s Manual 165
Rows(range)
Returns the number of rows in a reference or array.
Example: Rows(A1:A5) equals 5.
Type(value)
Returns a number indicating the data type of a value (number = 1,
text = 2, logical value = 4, error valu = 16).
VLookup(lookupValue, data, column)
Searches for a value in the leftmost column of a data table, and
then returns a value in the same row from a column you specify.
LookupValue is the value to be found in the fi rst column of the data
table. Data is the table of data. Column is the column number in the
data table from which the matching value is returned.
Database Functions
Daverage(database, fi eld, criteria)
Averages the values in the specifi ed database column matching the
conditions.
Dcount(database, fi eld, criteria)
Counts the cells containing numbers in the specifi ed database
column matching the conditions.
Dcounta(database, fi eld, criteria)
Counts nonblank cells in the specifi ed database column matching the
conditions.
Dget(database, fi eld, criteria)
Extracts a single value from the specifi ed database column matching
the conditions.
Dmax(database, fi eld, criteria)
Returns the largest number in the specifi ed database column
matching the conditions.
Dmin(database, fi eld, criteria)
Returns the smallest number in the specifi ed database column
matching the conditions.
Dproduct(database, fi eld, criteria)
Multiplies the values in the specifi ed database column matching the
conditions.