Microsoft Office Tutorials and References
In Depth Information
Database- and List-Management Functions
For example, to learn more about the DCOUNT function, you’d go to the Chapter 3, covering
“Database- and List-Management Functions.”
Database- and List-Management Functions
DAVERAGE
Indicates the average of the values that meet the specified criteria.
Counts the number of cells that contain numbers that meet the
specified criteria.
DCOUNT
Counts nonblank cells containing numbers or text that meet the
specified criteria.
DCOUNTA
Returns a single value that meets the specified criteria.
DGET
Extracts the highest value that meets the specified criteria.
DMAX
Extracts the lowest value that meets the specified criteria.
DMIN
Returns the product of multiplying the values that meet the
specified criteria.
DPRODUCT
Returns the calculation of the standard deviation of a population,
based on the sum of the whole population.
DSTDEV
Returns the total of the values that meet the specified criteria.
DSUM
Estimates the variance of a sample population, based on the
values that meet the specified criteria.
DVAR
Returns the calculation of the variance of an entire population,
based on the values that meet the specified criteria.
DVARP
Returns a value of data stored in a pivot table.
GETPIVOTDATA
Date and Time Functions
DATE
Returns the DATEVALUE as a serial number.
Converts a text date to a DATEVALUE as a serial number.
DATEVALUE
Returns the corresponding day of the month as a serial number,
from 1 to 31.
DAY
Returns the number of days between two set dates that you specify.
DAYS360
Returns the value or serial number of the date specified by you
and the number of months before or after the specified date. Use
EDATE to calculate the maturity date or date due that falls on the
same day of the month as the date of issue.
EDATE
Returns the calculated maturity dates or dates due that fall in the
last day of the month.
EOMONTH
Search JabSto ::




Custom Search