You don't need complex formulas to summarize thousands of rows when PivotTables can do the heavy lifting for you.
If you can write an Excel formula, you can build your own function.