Functions: Flexaverage and Average, Maxaverage, Dropaverage
Description:
The mean functions calculate the arithmetic mean of a selection - unlimited - of columns.
Each function has its own peculiarity, but in most cases, FLEXAVERAGE is the one to be used.
The mean functions calculate the arithmetic mean of a selection - unlimited - of columns.
Each function has its own peculiarity, but in most cases, FLEXAVERAGE is the one to be used.
FLEXAVERAGE
Arithmetic mean of all columns included. Skip empty cellsFLEXAVERAGE (column, column, column, column ...)
You must insert any value (p.e. 0) in one empty cell if you want it to be included in the calculation.
AVERAGE
Kept for legacy reasons, actually does exactly the same es Flexaverage.MAXAVERAGE
It takes the N maximum values of a selection of columns and calculates their arithmetic mean.Skip empty cells
MAXAVERAGE (Number of maximum columns to take into account, column, column, column ...)
DROPAVERAGE
Discard the minimum N values of a selection of columns and calculate their arithmetic mean. Skip empty cellsDROPAVERAGE (Number of minimum columns to drop, column, column, column ...)
Example
These are our sample data. In each cell the values that are taken into account with each function are shown.
Related articles
Rounding a Formula's result
Formulas: IF condition
Formulas, apply limits to results
Your first Formula
!-
Download Puedes descargar este ejemplo y su configuración con una plantilla. Incluirá datos, columnas y los tipos de nota que se muestran en el artículo Desde tu iPad, descarga y Abre en iDoceo > contraseña 1234
-->