i am currently using sumifs to selectively grab data from one tab (29000 rows) for display in several other tabs. On any given destination tab, there is between 2000 and 15000 individual formulas, with four sets of criteria within each of these sumifs formula. Is there a better (more efficient or faster) way to set this up? Each time I recalculate the entire file takes a few minutes. if anyone has a good idea or needs further info to qualify their response, please just respond.