I can't find the right formula to distribute a production percentage when a product goes through multiple working centers.

I have my company production by weight, by percentage and by work center, so I can add all the percentages that belong to a specific work center. 

Production by work center:  

![Production by work center](https://i.imgur.com/GSPVIXQ.png) 

The formula I'm using is: 

```
=sumif(column_of_workcenters,work_center,column_of_percentages)

```

With cell references it looks something like this:

```
=SUMAR.SI($H$44:$H$50,"*"&J44&"*",$G$44:$G$50)

```

Formula for sum:  

![Formula for sum](https://i.imgur.com/koVpUCs.png)

I have tried several combinations of count and sumifs formulas with no luck. I think the problem is the "sum if contains workcenter" approach.

If a product have multiple work centers assigned, they all add instead of distribute equally. 

Current values:  

![Current values](https://i.imgur.com/wmPxJNz.png) 

It should be something like this: 

Expected values:  

![Expected values](https://i.imgur.com/kBSvldD.png) 

Any help is appreciated.