Sumif does not calculate beyond 1000 rows

[lisay]

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

 

[Fred Smith]

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]

My formula is: =sumif(a2:a20000, Sheet5!E2, L2:L20000).

Col A .... Col L
1414 $1000
1414 $500


Sheet5:
Col E Col Result
1414 *** formuls here*** result should be $1500


Thanks!

 

[lisay]

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.

 

[Bernard Liengme]

Very odd. Want to send me a sample file? Get my email from my website
best wishes

 

[Fred Smith]

Sounds like a problem with your laptop, not Excel. If you're sure you have
exactly the same data on each computer, I would reinstall Excel.

My bet, however, is that your data isn't exactly what you think it is.

Regards,
Fred

 

[lisay]

I used the same data file on both laptop and one works while the other does
not. So, I know it is not a data problem. Because the data has confidential
info, I will have to dummy out the data first. What I might try first is
re-install Excel and see what happens.

Thank you both, for your suggestions. Will let you know once Excel is
reinstalled.

 

[lisay]

The re-install of Excel 2003 fixed the problem. Not sure what happened.
Thanks!