View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stephen Stephen is offline
external usenet poster
 
Posts: 106
Default Row Limitation in SUMPRODUCT

Is there a limit on the number of rows that can be referenced in a
SUMPRODUCT's array reference? When I try to reference arrays with ~2200
rows the formular no longer works. My sumproduct formular is using two
criteria arrays and one array of results to sum.

Thanks for any help that can be offer.
--
Stephen