How to get average of remaining (unsold) stock?

[unsethi]

Here is my excel sheet having buying details on the left and the selling details on the right.
A2 is the total buying average.
I2 is the total selling average.
E2 is the remaining Stock.
E4 is the Cell where I need to get the desired result of average cost of remaining (unsold) stock.

I have tried to explain it while using the data of rows 6 and 7. The average buying cost of remaining (unsold) stock.

=((C6*(B6-H6)) + (C7*(B7-H7)))/((B6-H6)+(B7-H7))

Is there any formula or shortcut method to get the desired result for whole of the sheet data, i.e. average cost of all remaining (unsold) stock.

 

[Joe4]

Cross-posted here: How to get average cost of remaining (unsold) stock?

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[Fluff]

And here How to get average cost of remaining (unsold) stock?

Have you asked this question anywhere else?

 

[unsethi]

Got the solution from Chandoo Forum.

How to get average cost of remaining (unsold) stock?

Here is my excel sheet having buying details on the left and the selling details on the right. A2 is the total buying average. I2 is the total selling average. E2 is the remaining Stock. E4 is the Cell where I need to get the desired result of average cost of remaining (unsold) stock. I have...

chandoo.org