Tuesday, June 28, 2011

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.


Post a Comment

Search This Blog


Related Posts Plugin for WordPress, Blogger...
Twitter Delicious Facebook Digg Stumbleupon Favorites More