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))
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.