This article describes the formula syntax of the MONTE.AVERAGE function.
Calculate the average of cell over a simulation.
MONTE.AVERAGE(cell, _reset)
cell is reference to a cell whos average is to be computed. _reset is an optional boolean to reset the calculation.
Calculate the running average over the course of the simulation.
If the output range has two cells then the second cell is used to
store the count. This is required if the mean is _reset
during a simulation.