L
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.
(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.