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).
AVERAGEA
The arithmetic mean of a list or array of numbers (including text and logical values).
COUNTA
The number of non blank cells in a list or cell range (including text and logical values).
DCOUNTA
The total number of non blank cells in a column satisfying certain conditions.
MAXA
The largest value in a list or array of numbers (including text and logical values).
MINA
The smallest value in a list or array of numbers (including text and logical values).
STDEVA
The standard deviation based on a sample (including text and logical values).
STDEVPA
The standard deviation based on an entire population (including text and logical values).
VARA
The variance based on a sample (including text and logical values).
VARPA
The variance based on an entire population (including text and logical values).

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited TopPrevNext