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.

 =SUMPRODUCT(C3:C11*EXACT(B3:B11,B14)) 
SUMPRODUCT and EXACT Function

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.