MAX(), MAXIFS(), MIN(), MINIFS(), SUM(), SUMIF(), SUMIFS(), AVERAGE(), AVERAGEIFS(), MEDIAN(), MODE(), RANK.EQ(), and RANK.AVG() functions support only NUMERIC parameters. If at least one of their parameters is detected as non-NUMERIC at compile time, it results in an error. If all arguments of the MAX(), MAXIFS(), MIN(), MINIFS(), SUM(), SUMIF(), SUMIFS() are absent these functions return a zero. The AVERAGE() and AVERAGEIFS() function does not count the absent parameters.
These functions support only BOOLEAN parameters. If at least one of the parameters is detected as non-BOOLEAN at compile time, it results in an error. An absent parameter is considered false. The OR() and AND() functions require that at least one parameter is present.
There are no special considerations.