{description}
{excerpt}When grouping rows, [SummaryRows|Worksheet.SummaryRows] determines where the summary rows for the groups are located. By default the summary rows are located below the groupings.{excerpt}
{signature:C#}
 public SummaryRowsLocation SummaryRows{ get; set; }
{signature}{signature:vb.net}
Public Property SummaryRows() As SummaryRowsLocation
{signature}
{example}{code:csharp|title=C#}

          //--- Get SummaryRows
          Worksheet.SummaryRowsLocation location = ws.SummaryRows;

          //--- Set SummaryRows
          ws.SummaryRows = Worksheet.SummaryLocation.Above;
        {code}
{code:vb.net|title=vb.net}

          '--- Get SummaryRows
          Dim location As Worksheet.SummaryRowsLocation = ws.SummaryRows

          '--- Set SummaryRows
          ws.SummaryRows = Worksheet.SummaryLocation.Above
        {code}

{example}