here is another Excel Formula Challenge, you know what Sumif will not work on the data shown in screenshot below, the challenge is to mimic sumif result with excel native function

Will upload the solution soon, try yourself and post your solution in comment box.

Download the file from here Excel-Formula-Challenge-9.xlsx (54 downloads)

Here is the solution Excel-Formula-Challenge-9-Solution.xlsx (94 downloads)