SUMPRODUCT and EXACT Formula
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.