Calculates the average of a list of arguments, including numbers, text, and logical values.
Cette fonction fonctionne de la même façon dans Google Sheets que dans Excel — même syntaxe et mêmes arguments.
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)Résultat : 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.