[]
Represents a options that determines which values to ignore in the evaluation range for the function.
public enum AggregateOption : byte
Public Enum AggregateOption As Byte
| Name | Description |
|---|---|
| IgnoreError | Ignore error values. |
| IgnoreErrorNestedAggregation | Ignore error values, nested SUBTOTAL and AGGREGATE functions. |
| IgnoreHidden | Ignore hidden rows. |
| IgnoreHiddenError | Ignore hidden rows and error values. |
| IgnoreHiddenErrorNestedAggregation | Ignore hidden rows, error values, nested SUBTOTAL and AGGREGATE functions. |
| IgnoreHiddenNestedAggregation | Ignore hidden rows, nested SUBTOTAL and AGGREGATE functions. |
| IgnoreNestedAggregation | Ignore nested SUBTOTAL and AGGREGATE functions. |
| IgnoreNothing | Ignore nothing. |