After you have sorted the cells, make sure the row references have not become
scrambled.
--
Gary''s Student - gsnu200813


"Rookie_User" wrote:

I have a column that counts the number of rows given a specific condition.
So the column will have various totals in them. The data it counts is on a
separate worksheet. When I want to sort that column (the one using countif)
it will appear to sort largest to smallest and then when it completes it
doesn't actually sort correctly, zero appear first rather than a five let's
say and so on - any idea's?