View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_4_] Jim Thomlinson[_4_] is offline
external usenet poster
 
Posts: 1,119
Default What's faster -- array formula or UD function?

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.