I have some very large files (60-100 meg) where I want to get counts, sums, and averages for many sets of multiple criteria. I've previously used dsums, but each dsum takes up two rows and thus copying and editing formulas isn't as convenient. The dsum variety takes about 2 hours to calculate thousands of different dsums on a dataset. What is a faster alternative? Will sumifs take about the same amount of time and just be easier to deal with?
Thanx
Thanx