finding the sum of values stored at different columns

[Jannat]

Hello everyone, 

I have a column called " product ID", 

for each product ID there is one isnpection result (either ok or not ok), 

If the result is not ok the user can specify up to 5 defects (string), the user input is stored in pre made columns called "defect type 1, defect type 2, defect type 3, defect type 4 and defect type 5). I need to find the sum of each type of defect (58 type) from all the five columns. What is the best way to do it? 

 

Thanks,

[rocky09]

@Jannat

can you please post some sample data? (copy directly from excel and paste here)