BTW, another note, the other laptop that I got this to work also has Excel
2003. It does not make sense to me why this would be a problem on one laptop
and not working on another laptop with both having the same version of Excel.

"lisay" wrote:

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