Skip to content

AVERAGEIF

You are currently viewing a sample of the Cram Kit. Click here to unlock everything.

=AVERAGEIF(range, criteria, [average_range])

In terms of range and criteria for OSU's average number of hot dogs ate per participant in cell F4, once again they'll be the same as COUNTIF and SUMIF:

=AVERAGEIF(B2:B11, "OSU", [average_range])

To compute [average_range]...

To determine your [average_range], ask yourself where the values are that you're wanting to average are.

In our case, that's once again the values in cells C2:C11!

=AVERAGEIF(B2:B11, "OSU", C2:C11)

If the SUMIF and AVERAGEIF functions have the exact same values in this situation, then what's the difference between them?

With SUMIF, we're calculating the sum of the values in C2:C11, based on whether or not each number's corresponding school is OSU or Michigan.

With AVERAGEIF, we're calculating the average the values in C2:C11, based on whether or not each number's corresponding school is OSU or Michigan.

When we plug this into cell F4, we learn that OSU participants ate an average of 16 hot dogs.

To copy this over to G4 for Michigan participants, we just need to replace "OSU" with "Michigan".

=AVERAGEIF(B2:B11, "Michigan", C2:C11)

This shows us that Michigan participants ate on average 15.5 hot dogs.

Previous Concept
Back to Unit
Next Practice Exercise
Previous Concept
Back to Unit
Next Practice Exercise
Activate AutoScroll