sum negative and positive numbers

[majidsiddique]

hi all,
i have a problem in SUM:
below mention showing last value of cell H1= C1 - G1
i want to add positive number and negative numbers separately from range H1 to h19. can anybody tell me this.
- number total = (.68)
+ number total = .14
this is small data:

thanks

MD-ONYX30026	5.00	196,293.75		MD-ONYX30026	5	196,293.76	-0.01
MD-ONYX30026	10.00	392,587.54		MD-ONYX30026	10	392,587.52	0.02
MD-ONYX30026	2.00	78,517.53		MD-ONYX30026	2	78,517.50	0.03
MD-ONYX30026	73.00	2,865,888.75		MD-ONYX30026	73	2,865,888.87	-0.12
MD-ONYX30030	11.00	431,846.30		MD-ONYX30030	11	431,846.27	0.03
MD-ONYX30030	1.00	39,258.74		MD-ONYX30030	1	39,258.75	-0.01
MD-ONYX30030	2.00	78,517.40		MD-ONYX30030	2	78,517.50	-0.10
MD-ONYX30030	70.00	2,748,112.50		MD-ONYX30030	70	2,748,112.61	-0.11
MD-ONYX30034	10.00	392,587.50		MD-ONYX30034	10	392,587.52	-0.02
MD-ONYX30034	7.00	274,811.25		MD-ONYX30034	7	274,811.26	-0.01
MD-ONYX30034	1.00	39,258.80		MD-ONYX30034	1	39,258.75	0.05
MD-ONYX30034	72.00	2,826,630.00		MD-ONYX30034	72	2,826,630.12	-0.12
MD-ONYX30038	21.00	824,433.75		MD-ONYX30038	21	824,433.78	-0.03
MD-ONYX30038	1.00	39,258.75		MD-ONYX30038	1	39,258.75	0.00
MD-ONYX30038	2.00	78,517.50		MD-ONYX30038	2	78,517.50	0.00
MD-ONYX30038	71.00	2,787,371.25		MD-ONYX30038	71	2,787,371.37	-0.12
MD-ONYX35008	10.00	375,133.40		MD-ONYX35008	10	375,133.39	0.01
MD-ONYX35012	10.00	392,587.50		MD-ONYX35012	10	392,587.52	-0.02
MD-ONYX35015	5.00	196,293.75		MD-ONYX35015	5	196,293.76	-0.01

<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[Tetra201]

Try

=SUMIF(H1:H19,"<0")

and

=SUMIF(H1:H19,">0")

 

[majidsiddique]

Thanks Tetra201:
thanks a lot.

 

[Tetra201]

You are welcome.