XlFunc.Subtotal(IList<XlCellRange>, XlSummary, Boolean) Method

A SUBTOTAL mathematical function.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v24.1.Core.dll

NuGet Package: DevExpress.Printing.Core

Declaration

C#

public static IXlFormulaParameter Subtotal(
    IList<XlCellRange> ranges,
    XlSummary summary,
    bool ignoreHidden
)

VB.NET

Public Shared Function Subtotal(
    ranges As IList(Of XlCellRange),
    summary As XlSummary,
    ignoreHidden As Boolean
) As IXlFormulaParameter

Parameters

Name	Type	Description
ranges	IList<XlCellRange>	A list of XlCellRange objects which are the references to cells containing values for calculation.
summary	XlSummary	A XlSummary enumeration member that specifies the calculation type, i.e., the function used for calculation.
ignoreHidden	Boolean	True, to include hidden rows or columns in the calculation; otherwise, false.

Returns

Type	Description
IXlFormulaParameter	An IXlFormulaParameter object that is the function result.