Note: You need to select which function you want the subtotal to use. So, how do you get the total to change with changes you make on the filter? This is where you will use the Subtotal formula. But, as you can see, once you use this formula and change the anything from the filtered drop-down menu, the sales total doesn’t change with it: ![]() This is the standard way to find a total. ![]() Now, if you wanted to find the sales total, you can use the following formula: If you remember from last week’s blog post on Sorting and Filtering data, we have gone ahead and added the filter. Imagine you are running sales numbers using the following the spreadsheet: Today’s lesson is on using the subtotal formula to find various totals based on the filter option in Excel. If you know the right formulas and functions, you can find out just about anything you want to know about your data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |