SUMIF

=SUMIF(range, criteria, [sum_range])

With this, how can we compute the total number of hot dogs ate by OSU participants?

Our range is going to be the same as last time:

=SUMIF(B2:B11, criteria, [sum_range])

Our criteria is additionally going to be the same:

=SUMIF(B2:B11, "OSU", [sum_range])

Now, how can we determine the [sum_range]?

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

The values that we're wanting to sum exist in C2:C11, so we'll plug that into our [sum_range] like so!

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

When we plug this into cell F3, we're able to determine that OSU participants ate 96 hot dogs.

To copy this over to Michigan's cell, just write the same formula in G2 but replace "OSU" with "Michigan".

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

This shows us that Michigan participants at a total of 62 hot dogs.