The AVERAGEA() calculates the average of the given arguments. Numbers, text and logical values are included in the calculation too. If the cell contains text or the argument evaluates to FALSE, it is counted as value zero (0). If the argument evaluates to TRUE, it is counted as one (1). Note that empty cells are not counted.
De funksje AVERAGEA () berekkent it (rekkenkundige) gemiddelde fan de opjûne parameters. Getallen, tekst en Booleaanske wearden wurde allegear yn de berekkening meinommen. As in sel tekst befet, of in argumint dat Net- wier blykt te wêzen wurdt dizze as nul (0) rekkene. As it argumint Wier blykt, dan wurdt it rekkene as in ien (1). Opmerking: lege sellen wurde net meitelt.