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

Leave a Reply

SECOND Function

The SECOND function in Excel returns the second component of a specified time as a number between 0-59. Syntax: =SECOND(serial_number)

Read More »
Scroll to Top