Sums the results of all simulations for a given cell.

Syntax

=MM_SUM(Cell)

• Cell
  Cell whose results of simulations you want to sum.

Remark

• It is very similar to the MM_RESULT function, except it does not have loop specifications as parameters, which means that by using MM_SUM, you are keeping all the loops from your table for the specified cell. If Cell is a stochastic cell but without loop dimensions, then MM_RESULT and MM_SUM have exactly the same behavior. If you want to sum results from the dimensions of your loops, use the MM_RESULT function.

Example

Formula1: =MM_LOOP("Loop",C2:C4)*RAND() in cell A2

The cell containing the above formula has: 

• stochastic dimensions because of the RAND Excel function

• loop dimensions from Loop

Formula2: =MM_SUM(A2) in cell A3
It returns the sum of stochastic dimensions only, meaning that you can still navigate through dimensions of Loop in Mind.