Version

UltraCalcFunctionSubtotal Class

Calculates the subtotal in one of more references.
Syntax
'Declaration
 
Public Class UltraCalcFunctionSubtotal 
   Inherits BuiltInFunctionBase
public class UltraCalcFunctionSubtotal : BuiltInFunctionBase 
Remarks

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.

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, 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

See Also