Okay, I'm going to take a look at the count if function, I want to determine how many times did the Reds win. So if I were to just come over here and type equals count, if you'll see that there's count if and count ifs. So, use count if singular, if you just want to be one condition given condition, use multiple conditions with the count ifs. Okay, so it's going to ask me for the range and the criteria. So my range will be this group of cells here q2 through q 16. Comma, and my criteria is going to be reds, select p 21.

There, or I could have typed in quotation marks reds. Okay, so awesome. If I were to type Astros', it's going to show five in that setting right there. That is the count if you can also find it under more functions, statistics. Count if and count ifs there.