Excel 2003

I have a spreadsheet currently with 7423 rows and 13 columns. One of
the columns has a Countif formula (actually three such formulas
connected by ampersands).

In that cell in that column in the last two row, the values evaluate
incorrectly. If I sort the spreadsheet and go back to the rows that
used to be the last rows (now in the middle of the table) and
Calculate, those rows correct themselves, but the new last two rows
evaluate to incorrect values.

Any ideas on this? Perhaps I happen to have reached some limit.
Thanks.

wal explained on 2/5/2011 :
> Excel 2003
>
> I have a spreadsheet currently with 7423 rows and 13 columns. One of
> the columns has a Countif formula (actually three such formulas
> connected by ampersands).
>
> In that cell in that column in the last two row, the values evaluate
> incorrectly. If I sort the spreadsheet and go back to the rows that
> used to be the last rows (now in the middle of the table) and
> Calculate, those rows correct themselves, but the new last two rows
> evaluate to incorrect values.
>
> Any ideas on this? Perhaps I happen to have reached some limit.
> Thanks.

Did you check to see if your formulas correctly use absolute/relative
refs?

Are you sorting entire rows of data, or at the very least all the rows
of Data?

Can you post your formula[s]?

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

on 2/5/2011, GS supposed :
> Are you sorting entire rows of data, or at the very least all the rows of
> Data?

This line should read:

Are you sorting entire rows of data, or at the very least all the
rows/cols of Data?

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

Dummy error. When I checked my formulas more carefully, I realized I
had used a range name. The used area got expanded, but somehow the
bounds of the named range did not.

Thanks for your help.


On Feb 5, 10:04*pm, GS <g...@somewhere.net> wrote:
> on 2/5/2011, GS supposed :
>
> > Are you sorting entire rows of data, or at the very least all the rows of
> > Data?
>
> This line should read:
>
> Are you sorting entire rows of data, or at the very least all the
> rows/cols of Data?
>
> --
> Garry
>
> Free usenet access athttp://www.eternal-september.org
> ClassicVB Users Regroup! comp.lang.basic.visual.misc