Hi xl gurus
Actually I know how to use SUMIF function both in excel spreadsheet and in VBA.
I would like to know how it was written.
For example I can create something like VLOOKUP in VBA. But I cannot find a way to write SUMIF2 code which will do the same thing.
I actually was looping through all cells, but as I found later, it's not a good idea, because when I selected whole range E:E, UDF was running almost 1 minute. But 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..
So How was this done???
Bookmarks