MS Excel: Subtotal function to add unfiltered and unhidden values
Ken Atigari: Some times you want to filter a table and see the sum of some measures in the filtered table. This video will show you how to use Excel's subtotal function "=subtotal(9,A1:A50)" to achieve this.