In Excel 2003, there's a restriction of 1000 entries in a data filter. But
not Sumif. It will handle all 65536 rows available.

What formula are you using?

Regards,
Fred

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