Forum Discussion
Solved
Formula
I have a warehouse inventory list that I am working on. I have a warehouse inventory sheet, purchase sheet and an order sheet. I have item numbers for the warehouse products. I need the total cost...
Thank you! Where do you want the average?
Most items will be purchased multiple times. So I want each transaction to be taken into account when coming up with the average cost.