Excel Formula Challenge #9

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

Excel Formula Challenge #9

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)

3 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *