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
Will upload the solution soon, try yourself and post your solution in comment box.
Download the file from here Excel-Formula-Challenge-9.xlsx (60 downloads)
Here is the solution Excel-Formula-Challenge-9-Solution.xlsx (114 downloads)
Leave a Reply
Want to join the discussion?Feel free to contribute!
Great one bro. Keep uploading to sharpen up our Excel skills
First need to fill details of A column then we can extract result with sumif
Hi Michael, Have a look at the solution file