I'm trying to sort a column of data where either "totals" are displayed or "nothing" is displayed in those cells based on the following formula: =IF(SUM(Z15:AR15)>0,CalcuttaCalc(Z15:AH15,AJ15:AR15),"")

As you can see, if the sum is >0, then(Do calc) else "place nothing in that cell".

Then, I want to sort the column of 32 rows "descending". Because the "blank" cells have a formula in them, Excel 2003, treats the cells as having data, and places the "blank" cells at the "top" of the column, followed by the remaining "Descending" data.

There will ALWAYS be 32 rows but not all 32 rows will show a value in that "Column".

How do I keep the formulas in the columns, and sort "descending", but still have the "blank" cells appear "at the bottom".

Showing anything other than a "blank" cell is not exceptable.

I've search the internet for two days before writing you folks. Thanks... Jerry