khelgadi
Member
Hello Excel Masters!!
I want to calculate profit from buying and selling transactions by using FIFO method and matching the quantity.
the formula for profit is as simple as = (sell rate- buy rate) * qty, but the qty needs to extracted from the list of transactions. I have attached a file which contains data sheet and a sample report ( i have made it manually).
Requesting for your help, thanks in advance.
I want to calculate profit from buying and selling transactions by using FIFO method and matching the quantity.
the formula for profit is as simple as = (sell rate- buy rate) * qty, but the qty needs to extracted from the list of transactions. I have attached a file which contains data sheet and a sample report ( i have made it manually).
Requesting for your help, thanks in advance.