E
EG
More and more similar data will be added the spread sheet below as the weeks
go by. I am trying to keep a running total of the amounts in column J where
the corresponding values in the cells in column I is "CALL" and the value of
the cells in column C is "BUY".
In other words, I need a formula in D28 that adds all the numbers in column
J when the value of C and I of the same row is "BUY" and "CALL" respectively.
C D E F G H I
J
6 BUY 10 PFE 100 Jan-06 32.5 CALL 0.900
7 SELL -10 PFE 100 Jan-05 30 CALL 0.150
8 SELL -10 PFE 100 Jan-05 27.5 PUT 1.200
9 BUY 10 PFE 100 Jan-06 25 PUT 2.000
Hope this makes sense and someone can help me.
Thx.
EG
go by. I am trying to keep a running total of the amounts in column J where
the corresponding values in the cells in column I is "CALL" and the value of
the cells in column C is "BUY".
In other words, I need a formula in D28 that adds all the numbers in column
J when the value of C and I of the same row is "BUY" and "CALL" respectively.
C D E F G H I
J
6 BUY 10 PFE 100 Jan-06 32.5 CALL 0.900
7 SELL -10 PFE 100 Jan-05 30 CALL 0.150
8 SELL -10 PFE 100 Jan-05 27.5 PUT 1.200
9 BUY 10 PFE 100 Jan-06 25 PUT 2.000
Hope this makes sense and someone can help me.
Thx.
EG