View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
lisay lisay is offline
external usenet poster
 
Posts: 15
Default Sumif does not calculate beyond 1000 rows

Does anyone know if there is a setting in Excel 2003 where we set number of
rows a formula should pick up? I have a sumif formula to calculate range
from row 2 to 20,000. However, it only calculates the first 1000. Then, I
have to change the range to 1001 to 2000 for the next set. This only happens
on a particular laptop.

Thanks,
Lisa