UltraCalcFunctionSubtotal Class

Calculates the subtotal in one of more references.

Syntax

Visual Basic

'Declaration
 
Public Class UltraCalcFunctionSubtotal 
   Inherits BuiltInFunctionBase

C#

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.