Net Position = sum(a1:A3)
Average price = sumproduct((a1:a3),(b1:b3))/sum(a1:a3)
"carl" wrote in message
...

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.