Profit and Loss Average

[codingmehelp]

I have a list of items with buy prices ranging from $0.5 to $3000 and quantities can be bought from 0.5 a unit to thousands of units. Here is a link to the sheet

https://docs.google.com/spreadsheets/d/ ... sp=sharing

this is not an excel question I want to find the total/average percentage (not sure what this is called) from the percentage of each entry.

As you can see in the P&L Percentage showing a negative total percentage. This is incorrect since the total of P & L Column shows a positive value.

The Formula used to Calculate P & L =(E3/D3-C3/B3)*D3

The Formula used to Calculate P&L Percentage - this is the formula used to calculate total percentage NOT row-wise =(SUM(Sell_Costs_Proceeds)/Sum(Sell_Base_Qty)-sum(Buy_Costs_Proceeds)/sum(Buy_Base_Qty))/(sum(Buy_Costs_Proceeds)/sum(Buy_Base_Qty))

The percentage should obviously be positive.
Some key points:
Buy and Sell Numbers can be different so profit is accordingly calculated.
the quantity has a huge disparity some quantities are less in 1 (0.2) and some thousands (17237). Cost is the same some costs are very high and some low.

thanks