Sorting pos. & neg. numbers in a cell

[LZW63]

In a single cell I have both positive and negative numbers
(representing an annual total). I'm trying to sort them by pos.
and neg.

I'm currently using a SUMIF(range, ">0", range) and another for
<0, but that doesn't sort them properly.

Example: I have a cell with the following:

=123649+113634+279384+129487-12045

when I use SUMIF for positive, I get 877,599 but when I use it
for neg. I get 0.

Any ideas?

Thanks.

 

[Earl Kiosterud]

LZ,

Your formula returns only one value to the cell -- the total. That's what
the SUMIF is seeing. There is no Excel command that will change the order
of those numbers within the formula.

Normally, you put each value in a separate cell, and add them with =SUM.
The negative values will still be negative (get subtracted). Then you can
sort the column.