SUMPRODUCT and EXACT Formula

SUMPRODUCT and EXACT Formula

In this tutorial, we will combine the SUMPRODUCT and EXACT Function in a formula to determine the total number of Wins for Ohio State.

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.

SUMPRODUCT and EXACT Function

Was this article helpful?

Leave a Reply