AVERAGEIFS
A function that averages only the values meeting every condition you give it. The range to average comes first, then pairs of condition range and criterion.
A function that averages only the values meeting every condition you give it. The range to average comes first, then pairs of condition range and criterion.