Thread: Sumproduct Question
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Elkar Elkar is offline
external usenet poster
  
Posts: 964
Default Sumproduct Question
In Excel 2003 or earlier, the limit is 30 arrays. In Excel 2007, the limit
is 255.

HTH,
Elkar


"Sandy" wrote:

Is there a limit to the criterium that can be used in sumproduct?
Thanks!
Reply With QuoteReply With Quote