Formulas and Functions Help
- Welcome
- Intro to formulas and functions
-
- ACCRINT
- ACCRINTM
- BONDDURATION
- BONDMDURATION
- COUPDAYBS
- COUPDAYS
- COUPDAYSNC
- COUPNUM
- CUMIPMT
- CUMPRINC
- CURRENCY
- CURRENCYCODE
- CURRENCYCONVERT
- CURRENCYH
- DB
- DDB
- DISC
- EFFECT
- FV
- INTRATE
- IPMT
- IRR
- ISPMT
- MIRR
- NOMINAL
- NPER
- NPV
- PMT
- PPMT
- PRICE
- PRICEDISC
- PRICEMAT
- PV
- RATE
- RECEIVED
- SLN
- STOCK
- STOCKH
- SYD
- VDB
- XIRR
- XNPV
- YIELD
- YIELDDISC
- YIELDMAT
-
- AVEDEV
- AVERAGE
- AVERAGEA
- AVERAGEIF
- AVERAGEIFS
- BETADIST
- BETAINV
- BINOMDIST
- CHIDIST
- CHIINV
- CHITEST
- CONFIDENCE
- CORREL
- COUNT
- COUNTA
- COUNTBLANK
- COUNTIF
- COUNTIFS
- COVAR
- CRITBINOM
- DEVSQ
- EXPONDIST
- FDIST
- FINV
- FORECAST
- FREQUENCY
- GAMMADIST
- GAMMAINV
- GAMMALN
- GEOMEAN
- HARMEAN
- INTERCEPT
- LARGE
- LINEST
- LOGINV
- LOGNORMDIST
- MAX
- MAXA
- MAXIFS
- MEDIAN
- MIN
- MINA
- MINIFS
- MODE
- NEGBINOMDIST
- NORMDIST
- NORMINV
- NORMSDIST
- NORMSINV
- PERCENTILE
- PERCENTRANK
- PERMUT
- POISSON
- PROB
- QUARTILE
- RANK
- SLOPE
- SMALL
- STANDARDIZE
- STDEV
- STDEVA
- STDEVP
- STDEVPA
- TDIST
- TINV
- TTEST
- VAR
- VARA
- VARP
- VARPA
- WEIBULL
- ZTEST
AVERAGEA
The AVERAGEA function returns the average (arithmetic mean) of a set containing any value.
AVERAGEA(value, value…)
value: Any value or a collection containing any values. Date/time values or duration values can’t be mixed with other value types. If either of these value types is included, all values must be of the same value type.
value…: Optionally include one or more additional values or collections.
Notes
A string value included in a referenced cell is given a value of 0. The boolean value FALSE is assigned a value of 0 and the boolean value TRUE is assigned a value of 1.
Examples |
|---|
=AVERAGEA(A1:D1) returns 2.5 if cells A1 to D1 contain 4, a, 6, b. The text values are counted as zeros in the sum of 10 and included in the count of values (4). Compare with =AVERAGE(A1:D1), which ignores the text values completely for a sum of 10, a count of 2 and an average of 5. =AVERAGEA(A2:D2) returns 4 if cells A2 to D2 contain 5, a, TRUE, 10. The text value counts as zero and TRUE counts as 1 for a sum of 16 and a count of 4. =AVERAGEA(A3:D3) returns 0.25 if cells A3 to D3 contain FALSE, FALSE, FALSE, TRUE. Each FALSE counts as zero and TRUE counts as 1 for a sum of 1 and a count of 4. =AVERAGEA("31/12/2010", "3d") returns an error as the values provided include both date/time and duration values. |