Using Subtotal in Excel
Summarise data quickly by using Subtotal Excel’s subtotal feature provides a quick and easy way of summarising tabular data. A common use of the feature is to display only the totals for different categories. For example suppose you want to calculate and display only the total units for each product from data (partly shown below) Step 1 Sort the data by the Product field. Click inside the […]