XlFunc.Sum(IXlFormulaParameter[]) Method

A SUM mathematical function.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v23.2.Core.dll

NuGet Package: DevExpress.Printing.Core

Declaration

C#

public static IXlFormulaParameter Sum(
    params IXlFormulaParameter[] parameters
)

VB.NET

Public Shared Function Sum(
    ParamArray parameters As IXlFormulaParameter()
) As IXlFormulaParameter

Parameters

Name	Type	Description
parameters	IXlFormulaParameter[]	An array of IXlFormulaParameter objects which are the constants, expressions or function results to sum.

Returns

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

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the Sum(IXlFormulaParameter[]) method.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

excel-export-library-generate-sales-report/CS/XLExportExampleSalesReport/Form1.cs#L327

using (IXlCell cell = row.CreateCell()) {
    cell.SetFormula(XlFunc.Sum(XlCellRange.FromLTRB(2, row.RowIndex, 5, row.RowIndex)));
    cell.ApplyFormatting(dataRowFormatting);

VB.NET

excel-export-library-generate-sales-report/VB/XLExportExampleSalesReport/Form1.vb#L340

Using cell As IXlCell = row.CreateCell()
    cell.SetFormula(XlFunc.Sum(XlCellRange.FromLTRB(2, row.RowIndex, 5, row.RowIndex)))
    cell.ApplyFormatting(dataRowFormatting)