A Functions

Functions that end with a "A"

AVERAGEAThe arithmetic mean of a list or array of numbers (including text and logical values).
COUNTAThe number of non blank cells in a list or cell range (including text and logical values).
DCOUNTAThe total number of non blank cells in a column satisfying certain conditions.
MAXAThe largest value in a list or array of numbers (including text and logical values).
MINAThe smallest value in a list or array of numbers (including text and logical values).
STDEVAThe standard deviation based on a sample (including text and logical values).
STDEVPAThe standard deviation based on an entire population (including text and logical values).
VARAThe variance based on a sample (including text and logical values).
VARPAThe variance based on an entire population (including text and logical values).



© 2017 Better Solutions Limited. All Rights Reserved. © 2017 Better Solutions Limited

PrevNext