Use these constants when you want to subtotal hidden and nonhidden numbers in a list. If there are other subtotals within ref1, ref2,… (or nested subtotals), these nested subtotals are ignored to avoid double counting.įor the function_num constants from 1 to 11, the SUBTOTAL function includes the values of rows hidden by the Hide Rows command under the Hide & Unhide submenu of the Format command in the Cells group on the Home tab in the Excel desktop application. Named ranges or references 2 to 254 for which you want the subtotal. The first named range or reference for which you want the subtotal. 1-11 includes manually-hidden rows, while 101-111 excludes them filtered-out cells are always excluded. The number 1-11 or 101-111 that specifies the function to use for the subtotal. The SUBTOTAL function syntax has the following arguments:įunction_num Required. Once the subtotal list is created, you can modify it by editing the SUBTOTAL function. It is generally easier to create a list with subtotals by using the Subtotal command in the Outline group on the Data tab in the Excel desktop application. Returns a subtotal in a list or database. This article describes the formula syntax and usage of the SUBTOTAL function in Microsoft Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |