![]() ![]() ![]() Once you’re satisfied with your selection, click “OK” to confirm the changes.Īfter you click OK, you should see that the rows in your spreadsheet are now arranged into groups.You can leave the “Replace current subtotals” and “Summary below data” options checked.Usually it’s the same column for which you’re doing the subtotals, as defined in Step 5. In the field “Add subtotals to”, select the column in which you want the subtotals to appear.Some of the most common operations are Sum, Count, and Average. In the “Use function” drop-down menu, choose one of the available options. Next, you have to choose which operation the subtotals should calculate.In the drop-down menu for “At each change in”, select the column that contains data you want to use for the subtotals. ![]()
0 Comments
Leave a Reply. |