Excel 2010 Bible

Part VII: Appendixes

920

TABLE A.3

Database Category Functions

Function What It Does

DAVERAGE Averages the values in a column of a list or database that match conditions you specify.

DCOUNT Counts the cells that contain numbers in a column of a list or database that match conditions you

specify.

DCOUNTA Counts the nonblank cells in a column of a list or database that match conditions you specify.

DGET Extracts a single value from a column of a list or database that matches conditions you specify.

DMAX Returns the largest number in a column of a list or database that matches conditions you specify.

DMIN Returns the smallest number in a column of a list or database that matches conditions you specify.

DPRODUCT Multiplies the values in a column of a list or database that match conditions you specify.

DSTDEV Estimates the standard deviation of a population based on a sample by using the numbers in a

column of a list or database that match conditions you specify.

DSTDEVP Calculates the standard deviation of a population based on the entire population, using the

numbers in a column of a list or database that match conditions you specify.

DSUM Adds the numbers in a column of a list or database that match conditions you specify.

DVAR Estimates the variance of a population based on a sample by using the numbers in a column of a

list or database that match conditions you specify.

DVARP Calculates the variance of a population based on the entire population by using the numbers in a

column of a list or database that match conditions you specify.

TABLE A.4

Date & Time Category Functions

Function What It Does

DATE Returns the serial number of a particular date.

DATEVALUE Converts a date in the form of text to a serial number.

DAY Converts a serial number to a day of the month.

DAYS360 Calculates the number of days between two dates, based on a 360-day year.

EDATE Returns the serial number of the date that is the indicated number of months before or after

the start date.

EOMONTH Returns the serial number of the last day of the month before or after a specified number of

months.

HOUR Converts a serial number to an hour.

56_474877-bapp01.indd 92056_474877-bapp01.indd 920 3/29/10 11:49 PM3/29/10 11:49 PM