Calculates the average of a list of arguments, including numbers, text, and logical values.
이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
AVERAGEA(value1, [value2], ...)The AVERAGEA function evaluates all arguments provided, treating text and empty strings as 0 and TRUE as 1. Unlike the standard AVERAGE function, which ignores non-numeric data, AVERAGEA includes these values in the calculation, making it useful for datasets containing mixed data types.
=AVERAGEA(10, "Text", TRUE)결과: 3.666666667
Calculates (10 + 0 + 1) / 3, where 'Text' is 0 and TRUE is 1.
AVERAGEA treats text as 0, which affects the denominator of the average calculation.