Cumul de comptage produit sur fonction SI

Good morning,

I wish to cumulate the total quantity of identical reference of material installed on the lines.

I have a database tab with all my material references and other tabs one per production line with in table different machines with a quantity of materials associated with my production machine.

The concern when the hardware reference appears on different machines gives me the result that the accumulation of the first line instead of accumulating the hardware present on all my machines.

Example in K50 the MOVITRAC B material gives me a result of 1 instead of 20.

Here is my formula for the K50:

=IF(COUNT.IF('ligne 1'!$O$9:$O$200,$G50),LOOKUPX($G50;'LINE 1'!$O$9:$O$200;'LINE 1'!$M$9 :$M$200);"")