# GrapeCity.CalcEngine.AggregateOption

## Content

<div class="doc-site-dotnet-api-container">




  <h1 id="GrapeCity_CalcEngine_AggregateOption" data-uid="GrapeCity.CalcEngine.AggregateOption" class="text-break">AggregateOption Enum
</h1>
  <div class="markdown level0 summary"><p>Represents a options that determines which values to ignore in the evaluation range for the function.</p>
</div>
  <div class="markdown level0 conceptual"></div>
  <h6><strong>Namespace</strong>: <a class="xref" href="GrapeCity.CalcEngine.html">GrapeCity.CalcEngine</a></h6>
  <h6><strong>Assembly</strong>: GrapeCity.Spreadsheet.dll</h6>
  <h5 id="GrapeCity_CalcEngine_AggregateOption_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">public enum AggregateOption : byte</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">Public Enum AggregateOption As Byte</code></pre>
  </div>
  <h3 id="fields">Fields
</h3>
  <table class="table table-bordered table-condensed">
    <thead>
      <tr>
        <th>Name</th>
        <th>Description</th>
      </tr>
    <thead>
    </thead></thead><tbody>
      <tr>
        <td id="GrapeCity_CalcEngine_AggregateOption_IgnoreError">IgnoreError</td>
        <td><p>Ignore error values.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_CalcEngine_AggregateOption_IgnoreErrorNestedAggregation">IgnoreErrorNestedAggregation</td>
        <td><p>Ignore error values, nested SUBTOTAL and AGGREGATE functions.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_CalcEngine_AggregateOption_IgnoreHidden">IgnoreHidden</td>
        <td><p>Ignore hidden rows.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_CalcEngine_AggregateOption_IgnoreHiddenError">IgnoreHiddenError</td>
        <td><p>Ignore hidden rows and error values.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_CalcEngine_AggregateOption_IgnoreHiddenErrorNestedAggregation">IgnoreHiddenErrorNestedAggregation</td>
        <td><p>Ignore hidden rows, error values, nested SUBTOTAL and AGGREGATE functions.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_CalcEngine_AggregateOption_IgnoreHiddenNestedAggregation">IgnoreHiddenNestedAggregation</td>
        <td><p>Ignore hidden rows, nested SUBTOTAL and AGGREGATE functions.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_CalcEngine_AggregateOption_IgnoreNestedAggregation">IgnoreNestedAggregation</td>
        <td><p>Ignore nested SUBTOTAL and AGGREGATE functions.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_CalcEngine_AggregateOption_IgnoreNothing">IgnoreNothing</td>
        <td><p>Ignore nothing.</p>
</td>
      </tr>
    </tbody>
  </table>
</div>