Sub Totals In Microsoft Excel

Microsoft Excel has a subtotal feature calculates subtotals and grand totals for columnar data. The feature supports eleven calculating processes: sum, count, average, maximum, minimum, product, count number, and more.

To calculate sub total: 

Here we will calculate the subtotals of the column 'Due' to count the number of books that are taken and  to be returned back on a particular date.

1) Select any cell in the grouping column.

 

2) Click the Data Menu and click Subtotal.

3) In the resulting dialog, choose Count from the Function dropdown.

4) Click OK and Excel will display a subtotal for each date in the Due column.

Posted in: Microsoft Excel 2003,Microsoft Office Support,PC Support,sub totals,Sub totals In excel 2003,Technical Support,Technical Support. TechSupp247