addition or substraction

F

FGOMEZ

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
 
T

Teodomiro

FGOMEZ said:
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
Click to expand...

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

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

In the second column,

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

Then sum each column to get what you need.
 
Top