Countif wrong in last row or two

  • Thread starter Thread starter wal
  • Start date Start date
W

wal

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.
Click to expand...

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?
 
Are you sorting entire rows of data, or at the very least all the rows of
Data?
Click to expand...

This line should read:

Are you sorting entire rows of data, or at the very least all the
rows/cols of Data?
 
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.
 
Back
Top