Dimitris254
Board Regular
- Joined
- Apr 25, 2016
- Messages
- 139
Hi all,
got this dilemma / problem. I have a sheet with 10 columns (with headers) and 20k rows. I want several sums based on multiple criteria.
i was thinking of looping though the rows with WorksheetFunction.SUMIFS, but would it be faster if i actually put the whole range in a variant and do the sumifs on the variant?
got this dilemma / problem. I have a sheet with 10 columns (with headers) and 20k rows. I want several sums based on multiple criteria.
i was thinking of looping though the rows with WorksheetFunction.SUMIFS, but would it be faster if i actually put the whole range in a variant and do the sumifs on the variant?