Methods summary
private static
array
|
#
__filter( mixed[] $database, mixed[] $criteria )
__filter
Parses the selection criteria, extracts the database rows that match those criteria, and
returns that subset of rows.
Parameters
- $database
The range of cells that makes up the list or database.
A database is a list of related data in which rows of related
information are records, and columns of data are fields. The
first row of the list contains labels for each column.
- $criteria
The range of cells that contains the conditions you specify.
You can use any range for the criteria argument, as long as it
includes at least one column label and at least one cell below
the column label in which you specify a condition for the
column.
Returns
array of mixed
|
public static
float
|
#
DAVERAGE( mixed[] $database, string|integer $field, mixed[] $criteria )
DAVERAGE
Averages the values in a column of a list or database that match conditions you specify.
Excel Function: DAVERAGE(database,field,criteria)
Parameters
- $database
The range of cells that makes up the list or database.
A database is a list of related data in which rows of related
information are records, and columns of data are fields. The
first row of the list contains labels for each column.
- $field
Indicates which column is used in the function. Enter the
column label enclosed between double quotation marks, such as
"Age" or "Yield," or a number (without quotation marks) that
represents the position of the column within the list: 1 for
the first column, 2 for the second column, and so on.
- $criteria
The range of cells that contains the conditions you specify.
You can use any range for the criteria argument, as long as it
includes at least one column label and at least one cell below
the column label in which you specify a condition for the
column.
Returns
float
Category
Database Functions
|
public static
integer
|
#
DCOUNT( mixed[] $database, string|integer $field, mixed[] $criteria )
DCOUNT
Counts the cells that contain numbers in a column of a list or database that match conditions
that you specify.
Excel Function: DCOUNT(database,[field],criteria)
Excel Function: DAVERAGE(database,field,criteria)
Parameters
- $database
The range of cells that makes up the list or database.
A database is a list of related data in which rows of related
information are records, and columns of data are fields. The
first row of the list contains labels for each column.
- $field
Indicates which column is used in the function. Enter the
column label enclosed between double quotation marks, such as
"Age" or "Yield," or a number (without quotation marks) that
represents the position of the column within the list: 1 for
the first column, 2 for the second column, and so on.
- $criteria
The range of cells that contains the conditions you specify.
You can use any range for the criteria argument, as long as it
includes at least one column label and at least one cell below
the column label in which you specify a condition for the
column.
Returns
integer
Category
Database Functions
Todo
The field argument is optional. If field is omitted, DCOUNT counts all records in the
database that match the criteria.
|
public static
integer
|
#
DCOUNTA( mixed[] $database, string|integer $field, mixed[] $criteria )
DCOUNTA
Counts the nonblank cells in a column of a list or database that match conditions that you specify.
Excel Function: DCOUNTA(database,[field],criteria)
Parameters
- $database
The range of cells that makes up the list or database.
A database is a list of related data in which rows of related
information are records, and columns of data are fields. The
first row of the list contains labels for each column.
- $field
Indicates which column is used in the function. Enter the
column label enclosed between double quotation marks, such as
"Age" or "Yield," or a number (without quotation marks) that
represents the position of the column within the list: 1 for
the first column, 2 for the second column, and so on.
- $criteria
The range of cells that contains the conditions you specify.
You can use any range for the criteria argument, as long as it
includes at least one column label and at least one cell below
the column label in which you specify a condition for the
column.
Returns
integer
Category
Database Functions
Todo
The field argument is optional. If field is omitted, DCOUNTA counts all records in the
database that match the criteria.
|
public static
mixed
|
#
DGET( mixed[] $database, string|integer $field, mixed[] $criteria )
DGET
Extracts a single value from a column of a list or database that matches conditions that you
specify.
Excel Function: DGET(database,field,criteria)
Parameters
- $database
The range of cells that makes up the list or database.
A database is a list of related data in which rows of related
information are records, and columns of data are fields. The
first row of the list contains labels for each column.
- $field
Indicates which column is used in the function. Enter the
column label enclosed between double quotation marks, such as
"Age" or "Yield," or a number (without quotation marks) that
represents the position of the column within the list: 1 for
the first column, 2 for the second column, and so on.
- $criteria
The range of cells that contains the conditions you specify.
You can use any range for the criteria argument, as long as it
includes at least one column label and at least one cell below
the column label in which you specify a condition for the
column.
Returns
mixed
Category
Database Functions
|
public static
float
|
#
DMAX( mixed[] $database, string|integer $field, mixed[] $criteria )
DMAX
Returns the largest number in a column of a list or database that matches conditions you that
specify.
Excel Function: DMAX(database,field,criteria)
Parameters
- $database
The range of cells that makes up the list or database.
A database is a list of related data in which rows of related
information are records, and columns of data are fields. The
first row of the list contains labels for each column.
- $field
Indicates which column is used in the function. Enter the
column label enclosed between double quotation marks, such as
"Age" or "Yield," or a number (without quotation marks) that
represents the position of the column within the list: 1 for
the first column, 2 for the second column, and so on.
- $criteria
The range of cells that contains the conditions you specify.
You can use any range for the criteria argument, as long as it
includes at least one column label and at least one cell below
the column label in which you specify a condition for the
column.
Returns
float
Category
Database Functions
|
public static
float
|
#
DMIN( mixed[] $database, string|integer $field, mixed[] $criteria )
DMIN
Returns the smallest number in a column of a list or database that matches conditions you that
specify.
Excel Function: DMIN(database,field,criteria)
Parameters
- $database
The range of cells that makes up the list or database.
A database is a list of related data in which rows of related
information are records, and columns of data are fields. The
first row of the list contains labels for each column.
- $field
Indicates which column is used in the function. Enter the
column label enclosed between double quotation marks, such as
"Age" or "Yield," or a number (without quotation marks) that
represents the position of the column within the list: 1 for
the first column, 2 for the second column, and so on.
- $criteria
The range of cells that contains the conditions you specify.
You can use any range for the criteria argument, as long as it
includes at least one column label and at least one cell below
the column label in which you specify a condition for the
column.
Returns
float
Category
Database Functions
|
public static
float
|
#
DPRODUCT( mixed[] $database, string|integer $field, mixed[] $criteria )
DPRODUCT
Multiplies the values in a column of a list or database that match conditions that you specify.
Excel Function: DPRODUCT(database,field,criteria)
Parameters
- $database
The range of cells that makes up the list or database.
A database is a list of related data in which rows of related
information are records, and columns of data are fields. The
first row of the list contains labels for each column.
- $field
Indicates which column is used in the function. Enter the
column label enclosed between double quotation marks, such as
"Age" or "Yield," or a number (without quotation marks) that
represents the position of the column within the list: 1 for
the first column, 2 for the second column, and so on.
- $criteria
The range of cells that contains the conditions you specify.
You can use any range for the criteria argument, as long as it
includes at least one column label and at least one cell below
the column label in which you specify a condition for the
column.
Returns
float
Category
Database Functions
|
public static
float
|
#
DSTDEV( mixed[] $database, string|integer $field, mixed[] $criteria )
DSTDEV
Estimates the standard deviation of a population based on a sample by using the numbers in a
column of a list or database that match conditions that you specify.
Excel Function: DSTDEV(database,field,criteria)
Parameters
- $database
The range of cells that makes up the list or database.
A database is a list of related data in which rows of related
information are records, and columns of data are fields. The
first row of the list contains labels for each column.
- $field
Indicates which column is used in the function. Enter the
column label enclosed between double quotation marks, such as
"Age" or "Yield," or a number (without quotation marks) that
represents the position of the column within the list: 1 for
the first column, 2 for the second column, and so on.
- $criteria
The range of cells that contains the conditions you specify.
You can use any range for the criteria argument, as long as it
includes at least one column label and at least one cell below
the column label in which you specify a condition for the
column.
Returns
float
Category
Database Functions
|
public static
float
|
#
DSTDEVP( mixed[] $database, string|integer $field, mixed[] $criteria )
DSTDEVP
Calculates the standard deviation of a population based on the entire population by using the
numbers in a column of a list or database that match conditions that you specify.
Excel Function: DSTDEVP(database,field,criteria)
Parameters
- $database
The range of cells that makes up the list or database.
A database is a list of related data in which rows of related
information are records, and columns of data are fields. The
first row of the list contains labels for each column.
- $field
Indicates which column is used in the function. Enter the
column label enclosed between double quotation marks, such as
"Age" or "Yield," or a number (without quotation marks) that
represents the position of the column within the list: 1 for
the first column, 2 for the second column, and so on.
- $criteria
The range of cells that contains the conditions you specify.
You can use any range for the criteria argument, as long as it
includes at least one column label and at least one cell below
the column label in which you specify a condition for the
column.
Returns
float
Category
Database Functions
|
public static
float
|
#
DSUM( mixed[] $database, string|integer $field, mixed[] $criteria )
DSUM
Adds the numbers in a column of a list or database that match conditions that you specify.
Excel Function: DSUM(database,field,criteria)
Parameters
- $database
The range of cells that makes up the list or database.
A database is a list of related data in which rows of related
information are records, and columns of data are fields. The
first row of the list contains labels for each column.
- $field
Indicates which column is used in the function. Enter the
column label enclosed between double quotation marks, such as
"Age" or "Yield," or a number (without quotation marks) that
represents the position of the column within the list: 1 for
the first column, 2 for the second column, and so on.
- $criteria
The range of cells that contains the conditions you specify.
You can use any range for the criteria argument, as long as it
includes at least one column label and at least one cell below
the column label in which you specify a condition for the
column.
Returns
float
Category
Database Functions
|
public static
float
|
#
DVAR( mixed[] $database, string|integer $field, mixed[] $criteria )
DVAR
Estimates the variance of a population based on a sample by using the numbers in a column
of a list or database that match conditions that you specify.
Excel Function: DVAR(database,field,criteria)
Parameters
- $database
The range of cells that makes up the list or database.
A database is a list of related data in which rows of related
information are records, and columns of data are fields. The
first row of the list contains labels for each column.
- $field
Indicates which column is used in the function. Enter the
column label enclosed between double quotation marks, such as
"Age" or "Yield," or a number (without quotation marks) that
represents the position of the column within the list: 1 for
the first column, 2 for the second column, and so on.
- $criteria
The range of cells that contains the conditions you specify.
You can use any range for the criteria argument, as long as it
includes at least one column label and at least one cell below
the column label in which you specify a condition for the
column.
Returns
float
Category
Database Functions
|
public static
float
|
#
DVARP( mixed[] $database, string|integer $field, mixed[] $criteria )
DVARP
Calculates the variance of a population based on the entire population by using the numbers
in a column of a list or database that match conditions that you specify.
Excel Function: DVARP(database,field,criteria)
Parameters
- $database
The range of cells that makes up the list or database.
A database is a list of related data in which rows of related
information are records, and columns of data are fields. The
first row of the list contains labels for each column.
- $field
Indicates which column is used in the function. Enter the
column label enclosed between double quotation marks, such as
"Age" or "Yield," or a number (without quotation marks) that
represents the position of the column within the list: 1 for
the first column, 2 for the second column, and so on.
- $criteria
The range of cells that contains the conditions you specify.
You can use any range for the criteria argument, as long as it
includes at least one column label and at least one cell below
the column label in which you specify a condition for the
column.
Returns
float
Category
Database Functions
|