![]() The result - subtotals are added for each store and province. Change the top dropdown from Province to Stores. This time, uncheck the box for "Replace Current Subtotals". If you wanted subtotals by province and store, first add them for the province. Be sure to start at the higher level first. ![]() You can also use this feature to do multiple subtotals. In less than 15 seconds, Excel has inserted hundreds of subtotals for you! By default, the final column is checked in the Add Subtotal To: section. The Subtotals dialog offers to insert subtotals every time that the Store changes. The following dialog box will be displayed. However - if you have 250 stores, it will take a really boring 75 minutes to add all of those totals. In cell C14, select Alt+Equals to put in a sum formula.ĭrag the fill handle (the square dot in the lower right corner of the cell pointer) to the right to copy the formula over to column D. Type a label in column A indicating that this is Store 100 Total. ![]() Go to the first row of data from the next store and select Insert - Row. You need to add a subtotal for each store.
0 Comments
Leave a Reply. |