You don't need complex formulas to summarize thousands of rows when PivotTables can do the heavy lifting for you.
Learn how you can combine PivotChart and Slicer objects to create an easy-to-use and dynamic data summarization. Excel 2010 introduced Slicers, which you can use to filter PivotTable and PivotChart ...