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.