Formula to find out the solution

Tweet

There are 3 columns 1) Name, 2) Task (Production, Delivery, Collection) & 3) No. of Turns and I want to find the total no. of turns for the Production in Task for all the individual and exclude the Delivery and Collection, and if the person has done only production it should not exclude the delivery and collection done by the same individual.