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

Sumif does not calculate beyond 1000 rows
 

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

Sumif does not calculate beyond 1000 rows
 

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!
"Fred Smith" wrote:

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

.

Sumif does not calculate beyond 1000 rows
 

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

Sumif does not calculate beyond 1000 rows
 

Very odd. Want to send me a sample file? Get my email from my website
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"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

Sumif does not calculate beyond 1000 rows
 

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

Sumif does not calculate beyond 1000 rows
 

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.

"Bernard Liengme" wrote:

Very odd. Want to send me a sample file? Get my email from my website
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"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

.

Sumif does not calculate beyond 1000 rows
 

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

"lisay" wrote:

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.

"Bernard Liengme" wrote:

Very odd. Want to send me a sample file? Get my email from my website
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"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

.