Excel Subtotals
Isaac Gottlieb · 2012
The Subtotal feature in Excel is an additional way to summarize data. The Subtotal—which does not necessarily apply to numerical sums only—can summarize and display data in a logical way. Excel can automatically calculate subtotal and grand total values in a table. When the user inserts automatic subtotals, Excel outlines the table so that he can display and hide the rows’ details for each subtotal. To insert subtotals, one will have to organize the table so that the rows the user wants to subtotal are grouped together by a certain parameter or type of information. Excel recalculates subtotal and grand total values automatically as the user edit the detail data.