This video we're going to look at how many times did the two we have reds winning at Great American ballpark. The value we want to do is how many were in attendance for there. So since we're going to be adding up numbers, we want the sum ifs. From the the math and the math and trig, we're going to come down and find some ifs. Plural, I recommend, always use the plural one, even if you just have one condition to use. See that the sum range is the first thing we want here.

So first, select the group of cells you want to calculate. Then below, we start to do the conditions. So in this scenario here, we're going to select the range the ballpark range, and the criteria is great American ballpark. The second condition is the house have to be met for winning. So selecting the range, q2 through q 16. And that condition is going to be the reds.

If I didn't have that text written around here, I would have just typed it in that scenario here. So when I hit OK, I'm going to get that that answer right there. So you'll see that let me just do a quick check point here. So that's the first game where we have reds winning at Great American ballpark 30,008 13. If I hold down the control key and select the other games with that same condition, that game and then this game, that game looks like a four. Yep.

So all four of these selected with using ctrl key I look down at the bottom here 115 440. That's what we have set up right there.