Count only if negitive and only if positive.

[gibbsmachine]

Hello all. I think I have an easy question for you. I have a column of numbers, some are negitive and some positive. I want to add only the negitive in one cell and only the positive in another cell.

[NBVC]

Try sumif:

=SUMIF(A1:A100,"<0")

and

=SUMIF(A1:A100,">0")

[gibbsmachine]

Thanks, that works. I was missing "" marks.

[NBVC]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save