# C1.Win.FlexGrid.AggregateEnum

## Content

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




  <h1 id="C1_Win_FlexGrid_AggregateEnum" data-uid="C1.Win.FlexGrid.AggregateEnum" class="text-break">AggregateEnum Enum
</h1>
  <div class="markdown level0 summary"><p>Specifies the type of aggregate function to calculate with the <a class="xref" href="C1.Win.FlexGrid.C1FlexGridBase.Aggregate.html#C1_Win_FlexGrid_C1FlexGridBase_Aggregate_C1_Win_FlexGrid_AggregateEnum_C1_Win_FlexGrid_CellRange_C1_Win_FlexGrid_AggregateFlags_">Aggregate(AggregateEnum, CellRange, AggregateFlags)</a> and
<span class="xref">C1.Win.FlexGrid.C1FlexGridBase.Subtotal(C1.Win.FlexGrid.AggregateEnum,System.Int32,System.Int32,System.Int32,System.Int32,System.String,C1.Win.FlexGrid.AggregateFlags,C1.Win.FlexGrid.RowColFlags)</span> methods.</p>
</div>
  <div class="markdown level0 conceptual"></div>
  <h6><strong>Namespace</strong>: <a class="xref" href="C1.Win.FlexGrid.html">C1.Win.FlexGrid</a></h6>
  <h6><strong>Assembly</strong>: C1.Win.FlexGrid.10.dll</h6>
  <h5 id="C1_Win_FlexGrid_AggregateEnum_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">public enum AggregateEnum</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">Public Enum AggregateEnum</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="C1_Win_FlexGrid_AggregateEnum_Average">Average</td>
        <td><p>Returns the average value of the non-empty cells in a range.</p>
</td>
      </tr>
      <tr>
        <td id="C1_Win_FlexGrid_AggregateEnum_Clear">Clear</td>
        <td><p>Clear existing aggregates. This setting is used with the <span class="xref">C1.Win.FlexGrid.C1FlexGridBase.Subtotal(C1.Win.FlexGrid.AggregateEnum,System.Int32,System.Int32,System.Int32,System.Int32,System.String,C1.Win.FlexGrid.AggregateFlags,C1.Win.FlexGrid.RowColFlags)</span> method
to clear any existing subtotals, usually before calculating new subtotals.</p>
</td>
      </tr>
      <tr>
        <td id="C1_Win_FlexGrid_AggregateEnum_Count">Count</td>
        <td><p>Returns the count of non-empty cells in a range.</p>
</td>
      </tr>
      <tr>
        <td id="C1_Win_FlexGrid_AggregateEnum_CountDistinct">CountDistinct</td>
        <td><p>Returns the count of unique non-empty cells in a range.</p>
</td>
      </tr>
      <tr>
        <td id="C1_Win_FlexGrid_AggregateEnum_Max">Max</td>
        <td><p>Returns the maximum value in a range.</p>
</td>
      </tr>
      <tr>
        <td id="C1_Win_FlexGrid_AggregateEnum_Min">Min</td>
        <td><p>Returns the minimum value in a range.</p>
</td>
      </tr>
      <tr>
        <td id="C1_Win_FlexGrid_AggregateEnum_None">None</td>
        <td><p>No aggregate. This setting is used with the <span class="xref">C1.Win.FlexGrid.C1FlexGridBase.Subtotal(C1.Win.FlexGrid.AggregateEnum,System.Int32,System.Int32,System.Int32,System.Int32,System.String,C1.Win.FlexGrid.AggregateFlags,C1.Win.FlexGrid.RowColFlags)</span> method to create an
outline tree without any numerical aggregates.</p>
</td>
      </tr>
      <tr>
        <td id="C1_Win_FlexGrid_AggregateEnum_Percent">Percent</td>
        <td><p>Percent of grand total. This setting is used with the <span class="xref">C1.Win.FlexGrid.C1FlexGridBase.Subtotal(C1.Win.FlexGrid.AggregateEnum,System.Int32,System.Int32,System.Int32,System.Int32,System.String,C1.Win.FlexGrid.AggregateFlags,C1.Win.FlexGrid.RowColFlags)</span> method to
calculate the percentage of the grand total represented by each sub group. (This setting can't
be used with the <a class="xref" href="C1.Win.FlexGrid.C1FlexGridBase.Aggregate.html#C1_Win_FlexGrid_C1FlexGridBase_Aggregate_C1_Win_FlexGrid_AggregateEnum_C1_Win_FlexGrid_CellRange_C1_Win_FlexGrid_AggregateFlags_">Aggregate(AggregateEnum, CellRange, AggregateFlags)</a> method).</p>
</td>
      </tr>
      <tr>
        <td id="C1_Win_FlexGrid_AggregateEnum_Std">Std</td>
        <td><p>Returns the sample standard deviation of the values in a range (uses the formula based on n-1).</p>
</td>
      </tr>
      <tr>
        <td id="C1_Win_FlexGrid_AggregateEnum_StdPop">StdPop</td>
        <td><p>Returns the population standard deviation of the values in a range (uses the formula based on n).</p>
</td>
      </tr>
      <tr>
        <td id="C1_Win_FlexGrid_AggregateEnum_Sum">Sum</td>
        <td><p>Returns the sum of all values in the range.</p>
</td>
      </tr>
      <tr>
        <td id="C1_Win_FlexGrid_AggregateEnum_Var">Var</td>
        <td><p>Returns the sample variance of the values in a range (uses the formula based on n-1).</p>
</td>
      </tr>
      <tr>
        <td id="C1_Win_FlexGrid_AggregateEnum_VarPop">VarPop</td>
        <td><p>Returns the population variance of the values in a range (uses the formula based on n).</p>
</td>
      </tr>
    </tbody>
  </table>
</div>