Thread: Speeding up Excel calculations
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stan Brown Stan Brown is offline
external usenet poster
  
Posts: 524
Default Speeding up Excel calculations
Sun, 28 Feb 2010 15:29:18 +0100 from JP Ronse :
- I have to use array functions because several conditions have to be
checked

You may or may not "have to use array functions". Consider
SUMPRODUCT, which is much, much faster and can "check multiple
conditions" just fine.

http://www.xldynamic.com/source/xld.SUMPRODUCT.html


--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...
Reply With QuoteReply With Quote