Returns the average of values in a range that meet multiple criteria.
=AVERAGEIFS(D1:D10, A1:A10, "East", B1:B10, ">100") averages values in D1:D10 where A is "East" and B>100.
