addition or substraction

  • Thread starter Thread starter FGOMEZ
  • Start date Start date
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
 
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.
 
Back
Top