COUNTIF, SUMIF, AVERAGEIF explained
It's the annual Ohio State vs. Michigan college football game. One of the biggest rivalries in the nation. Your family is originated in Ohio, so you all are massive OSU fans. You relatives, however, live in the state of Michigan, and are not afraid to boast about their fandom in front of you Buckeyes.
At your annual family tailgate, you compete in a hot dog eating competition, like any normal Midwestern family would.
Since you're the data analyst of the family, your parents ask you to use your Excel wizardry to compute the total number of competitors, the total number of hot dogs ate, and the average number of hot dogs ate. However, since this hot dog eating competition is between OSU and Michigan fans, we need to compute these values separately.
To do so, we can use the COUNTIF, SUMIF, and AVERAGEIF functions! These functions all work very similar to their base functions (COUNT, SUM, and AVERAGE) with one key difference:
They filter for cells that meet a certain condition, then COUNT, SUM, or AVERAGE those rows.
In our case, this condition will be the team that the participant is representing.
Coding a COUNTIF, SUMIF, AVERAGEIF
Below are the results of the hot dog eating competition:
We'll utilize the COUNTIF, SUMIF, and AVERAGEIF functions in orange cells on the right to compute the results of the competition.
PAID CONTENT This is the end of the preview. To unlock the rest, get the Excel Cram Kit (Exam 2), Lifetime Access or CSE 148 Cram Kit Bundle.
Already purchased? Click here to log in.