99% chance that the array formulas will be faster than UDF's. If you have the
need for speed sumproduct formulas are a little faster than array formulas.
Here is a link...
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
HTH...
Jim Thomlinson
"Steve" wrote:
I have a spreadsheet where I use a lot of array formulas to essentially
do a bunch of "SUM IFing". I am wondering in general if this method
calculates faster than were I to create some user defined functions
instead. Thanks.