I am new to the forum but not to Excel. I use it to sort data downloaded from the companies main frame. A typical query to the main frame yeailds a response that downloads to a database that is aprox 60 columns by about 5,000 rows. I use all kinds of sort tabs and helper tabs to create a one page data sheet that prints out a snapshot of the quires.

Sumifs and countifs are major helps. I am looking to learn how to make my formulas less repetitive by combining certain functions.