# FarPoint.Win.Spread.Model.AggregationType

## Content

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




  <h1 id="FarPoint_Win_Spread_Model_AggregationType" data-uid="FarPoint.Win.Spread.Model.AggregationType" class="text-break">AggregationType Enum
</h1>
  <div class="markdown level0 summary"><p>Specifies the type of aggregation on ranges of cells.</p>
</div>
  <div class="markdown level0 conceptual"></div>
  <h6><strong>Namespace</strong>: <a class="xref" href="FarPoint.Win.Spread.Model.html">FarPoint.Win.Spread.Model</a></h6>
  <h6><strong>Assembly</strong>: FarPoint.Win.Spread.dll</h6>
  <h5 id="FarPoint_Win_Spread_Model_AggregationType_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">public enum AggregationType</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">Public Enum AggregationType</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="FarPoint_Win_Spread_Model_AggregationType_Avg">Avg</td>
        <td><p>Returns the average of cells in a range.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_Model_AggregationType_AvgIgnoreHidden">AvgIgnoreHidden</td>
        <td><p>Returns the average of cells (ignores hidden values) in a range.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_Model_AggregationType_Count">Count</td>
        <td><p>Counts the number of cells in a range that contain numbers.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_Model_AggregationType_CountA">CountA</td>
        <td><p>Counts the number of cells in a range that are not empty.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_Model_AggregationType_CountAIgnoreHidden">CountAIgnoreHidden</td>
        <td><p>Counts the number of cells (ignores hidden values) in a range that are not empty.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_Model_AggregationType_CountIgnoreHidden">CountIgnoreHidden</td>
        <td><p>Counts the number of cells (ignores hidden values) in a range that contain numbers.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_Model_AggregationType_Custom">Custom</td>
        <td><p>Specifies custom aggregation.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_Model_AggregationType_Max">Max</td>
        <td><p>Returns the maximum value of cells in a range.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_Model_AggregationType_MaxIgnoreHidden">MaxIgnoreHidden</td>
        <td><p>Returns the maximum value of cells (ignores hidden values) in a range.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_Model_AggregationType_Min">Min</td>
        <td><p>Indicates the row count of the cells in the specified range of cells.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_Model_AggregationType_MinIgnoreHidden">MinIgnoreHidden</td>
        <td><p>Indicates the row count of the cells (ignores hidden values) in the specified range of cells.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_Model_AggregationType_None">None</td>
        <td><p>Indicates that aggregation for the sheet is not supported.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_Model_AggregationType_Product">Product</td>
        <td><p>Multiplies all the cells in a range and returns the product.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_Model_AggregationType_ProductIgnoreHidden">ProductIgnoreHidden</td>
        <td><p>Multiplies all the cells (ignores hidden values) in a range and returns the product.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_Model_AggregationType_StDev">StDev</td>
        <td><p>Returns the standard deviation for a set of cells in a range.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_Model_AggregationType_StDevIgnoreHidden">StDevIgnoreHidden</td>
        <td><p>Returns the standard deviation for a set of cells (ignores hidden values) in a range.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_Model_AggregationType_StDevP">StDevP</td>
        <td><p>Calculates standard deviation based on the entire population given as cells in a range.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_Model_AggregationType_StDevPIgnoreHidden">StDevPIgnoreHidden</td>
        <td><p>Calculates standard deviation based on the entire population given as cells (ignores hidden values) in a range.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_Model_AggregationType_Sum">Sum</td>
        <td><p>Sums values of cells in a range.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_Model_AggregationType_SumIgnoreHidden">SumIgnoreHidden</td>
        <td><p>Sums values of cells (ignores hidden values) in a range.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_Model_AggregationType_Var">Var</td>
        <td><p>Calculates variance based on a sample of a population.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_Model_AggregationType_VarIgnoreHidden">VarIgnoreHidden</td>
        <td><p>Calculates variance based on a sample (ignores hidden values) of a population.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_Model_AggregationType_VarP">VarP</td>
        <td><p>Calculates variance based on the entire population.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Win_Spread_Model_AggregationType_VarPIgnoreHidden">VarPIgnoreHidden</td>
        <td><p>Calculates variance based on the entire population (ignores hidden values).</p>
</td>
      </tr>
    </tbody>
  </table>
</div>