Mega Code Archive

 
Categories / MSOfficeExcel 2007 Tutorial / Database Functions
 

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.