Thread: Which is faster sum(if) as an array or sumproduct?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Neophyte Neophyte is offline
external usenet poster
  
Posts: 10
Default Which is faster sum(if) as an array or sumproduct?
I finally got my sum(if) based on more than one condition to work but it
takes my 1.8 Ghz chip 7 or 10 minutes to calculate the workbook with the
array formulas in 2003 Excel. Is Sumproduct any faster or do I just need to
use the free time to do something else?
Thanks,
Lee


Reply With QuoteReply With Quote