Chapter 13: Using Formulas for Conditional Analysis
13
condition. The country, gender, and medal are entered into cells I3:I5. We want to average
only those results that meet all three criteria.
=AVERAGEIFS(E3:E20,D3:D20,I3,B3:B20,"*"&I4,F3:F20,I5)FIGURE 13.16
Averaging on three conditions
The AVERAGEIFS function is structured similarly to the SUMIFS function. The first argu-
ment is the range to average, and it’s followed by up to 127 pairs of criteria_range/criteria
arguments. The three criteria pairs are as follows:
■ (^) D3:D20,I3 includes only those rows where the country code is SUI.
■ B3:B20,"*"&I4 includes only those rows where the event name ends with the
word Women.
■ F3:F20,I5 includes only those rows where the medal is GOLD.
When all three conditions are met, the time in the Result column is averaged.