Averageif with in average if

  • I have a data set that has Material (Col A) Plant (Col B) Storage Loc (col C), and Safety Stock (col D). The safety stock will be the same for every row with the same material plant combo even thought the Storage loc may change. I need to look up the total safety stock for each material. So i need a formula that will do a Sum if of the material but with a function inside it to average or find the unique values only at the material/plant level.

  • Hello,

    To properly answer your question ... why don't you attach a sample file with your next message ... :smile:

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!