Sumif does not calculate beyond 1000 rows

  • Thread starter Thread starter lisay
  • Start date Start date
L

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
 
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
 
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!
 
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.
 
Very odd. Want to send me a sample file? Get my email from my website
best wishes
 
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
 
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.
 
Back
Top