If you are calculating average price for tax purposes, it's only buys
(positive quantities) which affect the average. So use the formulas
suggested only for positive quantities.

In the example you gave, your average cost is $1.50. Even though you sold 5
at $1.25, the cost of the remaining 15 shares is still $1.50 each.

--
Regards,
Fred
Please reply to newsgroup, not e-mail


"mzehr" wrote in message
...
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.