Make the Excel Filter Feature Better than Ever with Subtotals
Do you use filtered lists in Excel? If you have tried to Sum a range while the list is filtered, well you have found that it just doesn’t work.
This video will teach you how to harness the power of a function that replaces the standard Sum, Average and Count functions. The Subtotal function is designed to calculate based only on the visible cells making it the perfect option for filtered lists.
[embedyt]http://youtu.be/pQj8ll7DXUs[/embedyt]