如何在Excel中的数组上使用VBA执行SumIf

I'm trying to come up with the fastest way to perform a SumIf function in Excel on a dataset that has approx. 110'000 lines. I've come up with three ways, but none of them are satisfying.I'm trying to come up with the fastest way to p