Writing own SUMIF in VBA

Hello bambino_32,

I'm guessing you have never taken a computer science course or done low level programming, correct?

If you were writing your own SumIf function, you would axiomatically intersect the formula ranges with the used range on the worksheet, and not process an entire column unless necessary.

Hello bambino_32,

Not a silly question. Knowing your level of understanding helps others when answering your question.

Originally Posted by bambino_32

...when we use built-in SUMIF function it makes everything in milliseconds. On the assumption of that, I think that built-in SUMIF code doesn't loop through all selected cells.

My understanding is such that the same is true of nearly all worksheet functions with the most notable exceptions being Arrays and SUMPRODUCT
which is why (like your own approach) these are so much more expensive in terms of performance

As shg has already outlined the first step to replicating SUMIF (without using SUMIF!) would be to limit the range appropriately.

The next might be to load those values into a VBA Array and process via the Array rather than via cell iteration ?

Another approach might be to use an Evaluate array along the lines of a basic test, pseudo-terms

Please Login or Register  to view this content.

EDIT: the above is obviously flawed in terms of handling wildcards, non-equal operators etc... it's meant purely as a basic demo.