In this tutorial, we will combine the SUMPRODUCT and EXACT Function in a formula to determine the total number of Wins for Ohio State. Yes, to be fair, Ohio State does win a lot of Football games. Go Buck’s.

Let’s being by looking at the formula.


We begin by defining the range we wish to sum, C3 through C11.

Next, we tie in the EXACT function by using the multiplication sign * and selecting cells B3 through B11.

Finally, we define our Text criteria in cell B14.