Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Database

 
DAVERAGEThe average of values in a column satisfying a condition.
DCOUNTThe total number of values in a column satisfying a condition.
DCOUNTAThe total number of non blank cells in a column satisfying a condition.
DGETThe single value from a column satisfying a condition.
DMAXThe maximum value in a column satisfying a condition.
DMINThe minimum value in a column satisfying a condition.
DPRODUCTThe product of values in a column satisfying a condition.
DSTDEVThe standard deviation of values in a column satisfying a condition.
DSTDEVPThe standard deviation of values in a column satisfying a condition.
DSUMThe sum of values in a column satisfying a condition.
DVARThe variance from a database column that satisfies a condition.
DVARPThe variance from a database column that satisfies a condition.
 

 Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top