In article . com,
says...
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.


Depends. On how the array formula is structured, how many of them are
there, and how the UDF is written.

It also possible -- and often is when the designer uses array formulas
solely to create overly complex formulas -- to improve the design of a
worksheet by *not* using array formulas.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions