majidsiddique
Board Regular
- Joined
- Oct 22, 2018
- Messages
- 164
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
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
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>