Well Paula that was a very challenging activity I must say. I would really encourage others to try it out as working out the formula really made the penny drop on how sumproduct works in terms of trues and falses and 1 and 0.
Looking at bundle 1, the answer should 94. I finally achieved that result with the formula =SUMPRODUCT(--(C2:C7="Y"),$B$2:$B$7)
Im looking forward to the solution.
Dernan I should have known you would be the first in here to solve this, you will have to wait now till next week when I publish the solutions to find out if you are right
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit