Microsoft Office Tutorials and References
In Depth Information
Using the DGET Function
field — This indicates which column is used in the function. fieldcan
be given as text, with the column label enclosed between double quota-
tion marks, such as "Age" or "Yield", or as a number that repres-
ents the position of the column within the list (for example, 1 for the
first column, 2 for the second column, and so on).
criteria — This is the range of cells that contains the conditions you
specify. You can use any range for the criteriaargument, as long as
it includes at least one column label and at least one cell below the
column label for specifying a condition for the column.