how to work with multiple subtotals in excel

Make sure the Summary Below Data check box is selected. Does anyone know a way to do multiple subtotals For example I would like subtotals by product, then by colour, then by size.Using the list in the Add Subtotal To box, choose the columns to which subtotals should be added.The Use Function drop-down list should be set to Sum.(This indicates where Excel will insert subtotals.) Make sure the At Each Change In drop-down list is set to Products.Click the Subtotal tool in the Outline group.Sort the table by the values in the Products column.You can insert subtotals and totals for this table by following these steps: Puede insertar un nivel de subtotales para un grupo de datos, como se muestra en el ejemplo siguiente ¿para que sirve En Excel, los subtotales se utilizan cuando trabaja con listas de datos ordenadas.

For instance, you may have a table that lists products in one column, quantities in another, and values in another. Tercer paso Seleccione una celda del rango. This works particularly well if you need subtotals based on a change in a particular column value. If you are using a well-defined data table (headings, multiple columns, etc.), then you may also want to use the built-in subtotals feature of Excel. The total inserted by Excel in cell B21 is the sum of all the subtotals in the column. So if you want a total for the range B3:B20 (which includes some subtotals), and you want the total to appear in B21, select cells B3 through B21.

When you are ready to add your total, select all the cells you want to total, as well as the cell where your total will appear. Insert your subtotals as normal in the column. The second way is to use the familiar AutoSum feature of Excel, accessible in the Editing group on the Home tab of the ribbon.

This works because the addition of the subtotals simply doubles the real value of the column. For instance, if you want to get a total for the range F10:F32, and there are subtotals interspersed in the column, you would use this formula for your total: Then, when it comes time to place your totals, simply use a modified SUM formula. The first approach is to place your various subtotals, as desired. In these instances, there are three different approaches you can use. The easiest solution would be to put subtotals and totals in different columns (like accountants often do), but this is not always practical for the data at hand. There are many times you may need to have both subtotals and totals in the same column of data.

How to work with multiple subtotals in excel