software

I have a columns with thousand of entries (rows)some are receivables ( ) and
others payables (-), how can I do a formula to add only receivables or
payables in other words negatives only or positives only.

Thanks
FGOMEZ Wrote:
gt; I have a columns with thousand of entries (rows)some are receivables ( )
gt; and
gt; others payables (-), how can I do a formula to add only receivables or
gt; payables in other words negatives only or positives only.
gt;
gt; Thanks

I would create two new columns. In the first column, put the formula

=if(a1gt;0,a1,quot;quot;)

In the second column,

=if(a1lt;0,a1,quot;quot;)

Then sum each column to get what you need.--
Teodomiro------------------------------------------------------------------------
Teodomiro's Profile: www.excelforum.com/member.php...oamp;userid=33140
View this thread: www.excelforum.com/showthread...hreadid=532429use the SUMIF function: sumif(range,quot;lt;0quot;) and sumif(range,quot;gt;0quot;)

quot;FGOMEZquot; wrote:

gt; I have a columns with thousand of entries (rows)some are receivables ( ) and
gt; others payables (-), how can I do a formula to add only receivables or
gt; payables in other words negatives only or positives only.
gt;
gt; Thanks
gt;
gt;
gt;
gt;
gt;

Thanks,
That is exactly what I was looking for.

Fernando

quot;dlwquot; gt; wrote in message
news
gt; use the SUMIF function: sumif(range,quot;lt;0quot;) and sumif(range,quot;gt;0quot;)
gt;
gt; quot;FGOMEZquot; wrote:
gt;
gt; gt; I have a columns with thousand of entries (rows)some are receivables ( )
and
gt; gt; others payables (-), how can I do a formula to add only receivables or
gt; gt; payables in other words negatives only or positives only.
gt; gt;
gt; gt; Thanks
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt;