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