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

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

 

[Tetra201]

Try

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

and

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

 

[majidsiddique]

Thanks Tetra201:
thanks a lot.

 

[Tetra201]

You are welcome.