Microsoft Office Tutorials and References
In Depth Information
Counts the cells that contain numbers in a column of a list or database that
match conditions you specify.
DCOUNT
Counts the nonblank cells in a column of a list or database that match condi-
tions you specify.
DCOUNTA
Extracts a single value from a column of a list or database that matches condi-
tions you specify.
DGET
Returns the largest number in a column of a list or database that matches
conditions you specify.
DMAX
Returns the smallest number in a column of a list or database that matches
conditions you specify.
DMIN
Multiplies the values in a column of a list or database that match conditions
you specify.
DPRODUCT
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 speci-
fy.
DSTDEV
Calculates the standard deviation of a population based on the entire popula-
tion, using the numbers in a column of a list or database that match conditions
you specify.
DSTDEVP
Adds the numbers in a column of a list or database that match conditions you
specify.
DSUM
Estimates the variance of a population based on a sample by using the num-
bers in a column of a list or database that match conditions you specify.
DVAR
Calculates the variance of a population based on the entire population by us-
ing the numbers in a column of a list or database that match conditions you
specify.
DVARP
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.
DAYS**
Returns the number of days between two dates.
Search JabSto ::




Custom Search