Calculate aggregates for Boolean values. This flag causes the value True to be interpreted as one, and False as zero. This option is useful for counting the number of checked check boxes in a range.

Calculate aggregates for dates instead of numerical values. Only a few aggregate functions are meaningful for dates: count, maximum, and minimum.

Exclude collapsed rows from the aggregate.

Exclude hidden rows and columns from the aggregate.

Exclude hidden rows from the aggregate.

Exclude node rows from aggregate. This option is useful when the grid contains subtotal rows, which are marked as nodes and contain values that are subtotals and should thus be excluded from aggregates.

Default setting. Include all rows and use numerical values only.