Skip to main content
Row

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

RangeExtensions.Count(CellRange, Boolean, Boolean) Method

Returns the number of cells in the current cell range that contain data.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v24.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

#Declaration

public static int Count(
    this CellRange range,
    bool ignoreHiddenRows,
    bool ignoreHiddenColumns
)

#Parameters

Name Type Description
range CellRange

A cell range for which the count is calculated.

ignoreHiddenRows Boolean

true to exclude hidden rows from calculation; otherwise, false.

ignoreHiddenColumns Boolean

true to exclude hidden columns from calculation; otherwise, false.

#Returns

Type Description
Int32

The number of cells with data.

#Remarks

Use the following extension methods to summarize data in a cell range. You can call these methods in the same way as instance methods of the CellRange object.

Method Description
RangeExtensions.Average Returns the average of numerical values in a cell range.
RangeExtensions.Count Returns the number of cells that contain data.
RangeExtensions.NumericalCount Returns the number of cells that contain numerical data.
RangeExtensions.Sum Returns the sum of numerical values in a cell range.
RangeExtensions.Max Returns the maximum numerical value in a cell range.
RangeExtensions.Min Returns the minimum numerical value in a cell range.

The following code example shows how to obtain summary values for selected cells in the Spreadsheet control.

CellRange selectedCells = spreadsheetControl1.Selection;
double average = selectedCells.Average(true, true);
double sum = selectedCells.Sum(true, true);
double count = selectedCells.Count(true, true);
double numCount = selectedCells.NumericalCount(true, true);
See Also