Sorting with =IF(ISBLANK not working as I'd like.

[slam]

I have the simple formula below in a column that I use to do a descending sort on.

=IF(ISBLANK(B3),"",SUM(E3:W3))

It puts the ISBLANK TRUE values at the top of the sort, but I want them at the bottom.

The descending sort works fine as =SUM(E3:W3)

How can I correct this?

Thanks

 

[drsarao]

Try:
=IF(ISBLANK(B3),0,SUM(E3:W3))

 

[slam]

Try:
=IF(ISBLANK(B3),0,SUM(E3:W3))

The point is I can't have a value displayed in the cell unless its > 0.

 

[drsarao]

You can always NOT display zeros by:
Tools-->Options-->View-->Zero values -- Uncheck.

Excel treats blanks created by formula as coming between the alphabets and numbers. Hence they land up above the numbers in reverse sort.