![]() ![]() ![]() In this example, cells H2:H50 are the cells that we want to sum. The second argument is the range of numbers that should be subtotaled. ![]() Most of the time you’ll use a 9, which is the SUM function. The first argument is a number that tells Excel which summary function to use in the subtotal. Within the brackets for the SUBTOTAL function there are two arguments, separated by a comma (or a semi-colon, depending on your regional settings). On Excel’s Standard toolbar, click the AutoSum button, or on the keyboard, press the Alt key and tap the equal sign key (Alt + =).īecause the list is filtered, a SUBTOTAL formula is inserted, instead of a SUM formula.Select the cell where you want the grand total.In this example, the Region column is filtered for “West”. Create a SUBTOTAL formulaĪ quick way to create a SUBTOTAL formula is to: Instead of SUM or COUNT, you can use the SUBTOTAL function, and only the filtered rows will be included in the grand total. There are only 3 orders visible, but the order count is calculated as 49. This list is filtered to show orders from the West Region.Īt a glance, you can see that the Grand Total is much higher than the records listed. If you used the SUM function in the grand total cell, the result won’t change if a filter is applied. Here’s how to total a filtered list in Excel. If you filter the Region column, so the list only shows one region’s sales, you’d like the total to include only those items. In Excel, you might have a long list of orders with a grand total at the end. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |