![]() Just remember to uncheck the Replace Current Subtotals option (step 4) when doing so – that’s the key to displaying different subtotaling functions for the same groups. When you want to evaluate the same group, but display a different function, add a new row. In this example, we displayed two Average functions in the first row. Subtotals in the same row will always be of the result of the same function. It’s such a simple step, but the return is huge! ![]() The first shows two averages and the second shows the total number of units in stock. Uncheck the Replace Current Subtotals option. This next step is very important – do not skip it.Uncheck the Unit Price and Units In Stock in the Add Subtotal To list and check Units In Stock.This time, select Sum from the Function dropdown.In Excel 2003, choose Subtotals from the Data menu. Click anywhere inside the data and click Subtotal (in the Outline group).You sorted the data earlier by Category, so you don’t need to sort again.For instance, let’s sum the number of units on order – without deleting the existing row of averages: When you need to display different subtotaling functions, add another row of subtotals. ![]() What you can’t do is add a different function to the same subtotaling row. You could add more averages if you wanted to. How easy was that? With just a few clicks, you generated the average price and stock for each product category.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |