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:
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

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

=if(a10,a1,"")

In the second column,

=if(a1<0,a1,"")

Then sum each column to get what you need.


--
Teodomiro


------------------------------------------------------------------------
Teodomiro's Profile: http://www.excelforum.com/member.php...o&userid=33140
View this thread: http://www.excelforum.com/showthread...hreadid=532429

use the SUMIF function: sumif(range,"<0") and sumif(range,"0")

"FGOMEZ" wrote:

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

Thanks,
That is exactly what I was looking for.

Fernando

"dlw" wrote in message
...
use the SUMIF function: sumif(range,"<0") and sumif(range,"0")

"FGOMEZ" wrote:

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