How to count "Same Purchase item Qty total" and "minus Same Sale Qty total " ??? make report

[krunal123]

How to count "Same Purchase item Qty total" and "minus Same Sale Qty total "

if Qty balance is "0" , not show entry in report Again.

 

[arthurbr]

For Item A =sumif(a2:a6,c11,c2:c6)-sumif(a2:a6,c11,f2:f6)
I leave it up to you to add the absolute/relative references
As to the "average rate" I do not know what you mean