Database functions : Database functions « Database functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Database functions
  3. Database functions

DatabaseFunctionName(database,field,criteria) returns the calculation result of selected database entries.

Database is the range of cells. The first row of the list contains labels for each column.

Field indicates which column is used in the function.

Criteria is the cells that contains at least one column label and at least one cell below specifying a condition for the column.









14.1.Database functions
14.1.1.Database functions
14.1.2.Use the equals sign ="=entry"Use the equals sign =
14.1.3.Use the equals sign with textUse the equals sign with text
14.1.4.Use wild card character: ? represents any single characterUse wild card character: ? represents any single character
14.1.5.Use wild card character:* represents any number of charactersUse wild card character:* represents any number of characters
14.1.6.Use the equals sign with valueUse the equals sign with value
14.1.7.Use greater thanUse greater than