![]() That is after all the best way to learn new things, experiment with your data. ![]() That way I will know the total cost of each shipment in my file. The Subtotal command allows you to automatically create groups and use common functions like SUM, COUNT, and AVERAGE to help summarize your data.For example, the Subtotal command could help to calculate the cost of office supplies by type from a large inventory order. Play around with some different data and functions to see what you come up with. Now as before, go to the Data tab on the ribbon, and select the Subtotal Button: Once you have that open, I will select At each change in Shipment Number, the Sum Function, and select subtotals for Discount, Net Amount, and Gross Amounts. I am not going into these in this blog, but this should give you some ideas to start experimenting with. There are other functions that you can use within the Subtotal Function such as: Max, Min, Product, Count Numbers, Standard Deviation, Standard Deviation for the Population, Variance, and Variance for the Population. ![]() By clicking the numbers in the top left I can reduce my file so that all I am looking at is my subtotals, I have highlighted all of my subtotals to make it easy to see what I have done. Here is what we get (the newest is highlighted in blue.)Īs you can see all of my subtotals are here for easy access and use. We will repeat our steps for setting up a subtotal, I am adding in the average of the weight, destination code and discount. Now let's add a subtotal for another column without deleting our existing subtotals. I now have the totals of the costs and the number of Packages in each shipment. I highlighted the first Subtotal results in green the Count Subtotal I just completed in yellow.
0 Comments
Leave a Reply. |