Running Total

[doublej0]

I need to keep a running total as follows (column letters are at the
top). For each EXO that has 021 subtract "T". For each EXI that has EXI
add "T". I need this for each number in "O". The formula does not need
to inlude the "PUR" or "0" in column R.

Thank you.
O P Q R S T
021 PUR 021 728.030
024 0 000 0.000
033 EXO 021 182.008
035 EXI 080 3.375
070 EXO 021 182.008
071 EXI 086 5.811
072 EXO 021 182.008
073 EXI 076 9.132
074 EXO 021 182.000
075 EXI 073 4.499
076 EXO 073 1.125
077 EXI 085 2.400
079 EXO 073 1.113
080 EXI 075 2.789
081 EXO 080 0.844
082 EXI 082 1.558
083 EXO 073 1.131
084 EXI 076 2.060
085 EXO 086 5.811
086 EXI 071 5.452
087 EXO 080 0.835
098 EXI 082 1.638
EXO 073 1.130
EXI 083 2.957
EXO 085 2.400
EXI 084 1.961
EXO 076 2.334
EXI 082 1.526
EXO 083 2.957
EXI 071 1.308
EXO 082 0.000
EXI 087 0.000
EXO 076 0.000
EXI 080 0.000
EXO 082 0.000
EXI 080 0.000
EXO 076 0.000
EXI 075 0.000
EXO 084 0.000
EXI 081 0.000
EXO 082 0.000
EXI 075 0.000

John.

 

[doublej0]

Figured it out. Used a sumif and if calculation.