Hello,
I have a table of data, and one of the columns generates a percentage.
Since it will sometimes give a DIV/0 error, the formula that generates
the percentage is:

=IF(SUM(I22:J22)=0,"",I22/SUM(I22:J22))

That way, if the divisor would be 0, it leaves the cell "empty."

However, when I then sort by this column in descending order, all of
the rows with "empty" percentages float to the top of the list. Below
them, the ones with data sort correctly.

I can change the formula to

=IF(SUM(I22:J22)=0,0,I22/SUM(I22:J22))

but that creates confusion between the ones that have no percentage and
the ones that legitimately have a percentage of zero.

Is there a way that I can have a truly empty cell instead of one with
"" in it? If so, would that help the sort? Is there another way I can
sort it? Any advice would be greatly appreciated...

Thanks to all.

Mike