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.