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?
For average, you should use AVERAGEIFS, but without knowing what your sheets look like it's hard to provide specific help.
Here is the file.
Thank you! Where do you want the average?