Hi Carl
Your net position is the is the sum of the Quantity or =Sum(A2:A4)
The average price is calculated as an array formula (Shift-Ctrl-Enter) as
follows:

=SUM((A2:A4)*(B2:B4))

"carl" wrote:


my table looks like so:

Quantity Price

10 1.50
10 1.50
-5 1.25

Is there a way for me to calculate my net position (+15) and my average
price of my net position.

thank you in advance.