View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre Ron Coderre is offline
external usenet poster
 
Posts: 2,118
Default Row Limitation in SUMPRODUCT

Can you post your formula, so we can see what you're working with?

--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"Stephen" wrote in message
...
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