Please enable JavaScript.
Coggle requires JavaScript to display documents.
FUNCTIONS (Formulates (SUM (SUM(range) or SUM(num1, num2, …) (Adds the…
FUNCTIONS
Formulates
SUM
SUM(range) or SUM(num1, num2, …)
-
AVERAGE
AVERAGE(SUM(number1,[number2],)
-
MIN
MIN(SUM(number1,[number2],…)
-
-
SUMIF
SUMIF(range, criteria, sum-range)
-
ROUND
Round (number, num_digits)
-
AVERAGEIF
AVERAGEIF(range, criteria, averagif-range)
-
-
-
Others
CONSOLIDATE
Sumarize data from separate range, consolidating the results, in a single output range.
-
-
-