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?
The average cost should be in the unit cost on the inventory sheet.
=IFERROR(SUMIFS(Table3[Total Cost], Table3[Item Number], [@[Inventory ID]])/SUMIFS(Table3[QTY], Table3[Item Number], [@[Inventory ID]]), "")
or if you prefer
=IFERROR(SUMIFS(Table3[Total Cost], Table3[Item Number], [@[Inventory ID]])/SUMIFS(Table3[QTY], Table3[Item Number], [@[Inventory ID]]), 0)