Leading the way in Microsoft Office Development
 Home|

Excel

|Word|PowerPoint|Consultancy|Feedback|Contact 
 Excel > Functions > Database

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

 Copyright © 2010 Better Solutions Limited. All Rights Reserved.Top