After filtering, the function will calculate with only the rows that are visible, allowing you to see customized results. If you have applied the Subtotal function to a section of your worksheet and want to see results for a specific category of information contained within that subtotal, you can hide rows by filtering the field. The subtotal appears in the selected cell and the formula appears in the Formula B ar.ĮXAMPLE: In the formula =SUBTOTAL(1,D2:D11), 1 designates the calculation from the Function_ numtext box as an average, and D2:D11 designates the cell range from the Ref1 text box. NOTE: You may select up to 29 different fields to include in the subtotal. Repeat step 6 for as many different cell ranges as necessary.
In the Ref1 text box, type the range of cells to be analyzed.HINT: For more information, refer to Function Numbers below. In the Function_num text box, type the number of the function you would like to perform The Function Arguments dialog box appears. In the Function Library group, click Math & Trig. This allows you to see the results.įrom the Ribbon, select the Formulas command tab. NOTE: If you are filtering your worksheet, make sure that the selected cell is below your data. Select the cell where you want the result of the function to appear. This determines what type of calculation will be performed. The Subtotal function is easily created with the Function Arguments dialog box.The first piece of information you will need is the function number below. It can be used with Tables or any range of data. The Subtotal function ignores values in rows hidden by a filter. Then, by filtering the data, the same calculation is performed on subsets of your data. The Subtotal function allows you to set up a calculation in your worksheet. This article is based on legacy software. (Archives) Microsoft Excel 2007: Functions: Subtotal
0 kommentar(er)
