Solved

# excel calculation

Posted on 2011-03-01

Is there a simple formula for figuring this out, the sum of the rows? See below for further explanation:

A B C D

S 825.2 1 3/1/2011 14:34

B 824.8 1 3/1/2011 14:35

B 821.2 1 3/1/2011 14:41

S 821.1 1 3/1/2011 14:41

The above columns show trading contracts.

Column A is S or B, meaning short or long. An S contract is a negative amount and a B contract is a positive amount.

Column B is the contract value.

Column C is the quantity of contracts traded

Column D is the date and doesn't matter for this calculation.

If the formula is working correctly, I would be able to select rows 1 and 2 and apply the formula and get a sum of 4 in Column E