How do I add positive and negative figures in the same column seperately

[ghrek]

I have a workbook that in column O it has positive and negative figures. What im trying to do is to have 2 seperate subtotals in the column with O999 Showing the value of all the positive figures added together and then O1000 with all the negative figures added together.

Can that be done?

 

[DanteAmor]

Try:

Dante Amor
	A														O
1															VALUES
2															23
3															45
4															67
5															-15
6															-20
7															78
8															89
9															-25
10
97
98
99															302
100															-60
Hoja3

Cell Formulas
Range	Formula
O99	O99	=SUMIF(O2:O98,">0")
O100	O100	=SUMIF(O2:O98,"<0")

Note: change in the formula 98 to 998, in minisheet it is only an example.
----- --