excel formula

October 28, 2006 7:43pm CST
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.
No responses