![]() Then select the Data tab on the ribbon, and click the Subtotal button which you’ll find in the Outline group. Once you have your data formatted properly make sure your cursor is within the table you want subtotaled, or better yet select the entire table to make sure Excel knows what should be included. ![]() This is because the automatic subtotal function looks for changes in the column that you want your subtotal based on in order to determine where to insert the subtotal lines. ![]() You can’t just have the sales rep on the first line of that section, like a heading. For example, if you have a list of sales that you want subtotaled by sales rep, first it must be sorted by sales rep and, second, the sales rep has to be entered on every line. And that field (column) needs to have an entry on every line. Logically, you’ll need to have the data in your list sorted by field you want to subtotal by. Did you know that, with just a few clicks, Excel can add subtotals and a grand total to your lists? In order for it to work you do have to start out with your data formatted correctly.
0 Comments
Leave a Reply. |