Prev: Two formulas in on cell based on two numbers in another cell?
Next: Creating "Billboard" Like Charts
From: lisay on 19 Mar 2010 15:29
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
From: Fred Smith on 19 Mar 2010 15:33
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" <lisay(a)discussions.microsoft.com> wrote in message
news:C7703EF0-B36E-4FC9-A225-359939CC2F5E(a)microsoft.com...
> 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

From: lisay on 19 Mar 2010 17:23
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" <lisay(a)discussions.microsoft.com> wrote in message
> news:C7703EF0-B36E-4FC9-A225-359939CC2F5E(a)microsoft.com...
> > 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
>
> .
>
From: lisay on 19 Mar 2010 17:25
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
From: Bernard Liengme on 19 Mar 2010 18:09
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" <lisay(a)discussions.microsoft.com> wrote in message
news:C7703EF0-B36E-4FC9-A225-359939CC2F5E(a)microsoft.com...
> 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

 |  Next  |  Last
Pages: 1 2
Prev: Two formulas in on cell based on two numbers in another cell?
Next: Creating "Billboard" Like Charts