Can anyone give me VBA coding or a formula to use for AVERAGEIF to place the answer in a specific cell from a dynamic range? I'm stumped.