Formulas and Functions Help
- Welcome
-
- 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
- Copyright
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 through 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 through D2 contain 5, a, TRUE, 10. The text value counts 0 and TRUE counts 1 for a sum of 16 and a count of 4. =AVERAGEA(A3:D3) returns 0.25 if cells A3 through D3 contain FALSE, FALSE, FALSE, TRUE. Each FALSE counts 0 and TRUE counts 1 for a sum of 1 and a count of 4. =AVERAGEA("12/31/2010", "3d") returns an error as the values provided include both date/time and duration values. |