!database,field,criteria!!Counts nonblank cells in the field (column) of records in the database that match the conditions you specify!is the range of cells that makes up the list or database. A database is a list of related data!is either the label of the column in double quotation marks or a number that represents the column's position in the list!is the range of cells that contains the conditions you specify. The range includes a column label and one cell below the label for a condition!
database,field,criteria!Adds the numbers in the field (column) of records in the database that match the conditions you specify!is ...
database,field,criteria!Averages the values in a column in a list or database that match conditions you specify!is the range ...
database,field,criteria!Calculates the standard deviation based on the entire population of selected database entries!is ...
database,field,criteria!Calculates variance based on the entire population of selected database entries!is the range of cells ...
database,field,criteria!Counts nonblank cells in the field (column) of records in the database that match the conditions ...
database,field,criteria!Counts the cells containing numbers in the field (column) of records in the database that match the ...
database,field,criteria!Estimates the standard deviation based on a sample from selected database entries!is the range of ...
database,field,criteria!Estimates variance based on a sample from selected database entries!is the range of cells that makes ...
database,field,criteria!Extracts from a database a single record that matches the conditions you specify!is the range of ...