database: a range in which rows of related information are records and columns of data are fields
field: a string or integer specifying which field is to be used
criteria: a range containing conditions
database is a range in which rows of related information are records and columns of data are fields. The first row of a database contains labels for each column.
field is a string or integer specifying which field is to be used. If field is an integer n then the nth column will be used. If field is a string, then the column with the matching label will be used.
criteria is a range containing conditions. The first row of a criteria should contain labels. Each label specifies to which field the conditions given in that column apply. Each cell below the label specifies a condition such as ">3" or "<9". An equality condition can be given by simply specifying a value, e. g. "3" or "Jody". For a record to be considered it must satisfy all conditions in at least one of the rows of criteria.