'Declaration Public Class UltraCalcFunctionSubtotal Inherits BuiltInFunctionBase
public class UltraCalcFunctionSubtotal : BuiltInFunctionBase
Subtotal(function_num, ref1, ref2,...)
Function_num is the type which should be calculated.
| Function_num (includes hidden values) | Function_num (ignores hidden values) | Function |
|---|---|---|
| 1 | 101 | AVERAGE |
| 2 | 102 | COUNT |
| 4 | 104 | MAX |
| 5 | 105 | MIN |
| 6 | 106 | PRODUCT |
| 7 | 107 | STDEV |
| 9 | 109 | SUM |
| 10 | 110 | VAR |
Ref1, ref2, ... are references for which you want to find the subtotal.
Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2