Help needed to program a function

[Mango1337]

Hi,

I need the function to take place in the "Mouvements inventaire" Tab:

If the cells in the 7th row (in orange-beige) = Oui, sum the oranges cell (I9, M9, Q9, etc) underneath and SUM the result that would appear in the B9 cell.

Example: If F7 = Oui, J7 = Non, N7 = Oui, then B9= I9(2) + Q9(3) = 5. See the attached filed

I would like this to be applicable to every row and to be able to add as many columns as I need.

Can someone help me with this matter ?

Thank you very much for your time.

[JohnTopley]

Try

=SUMPRODUCT(($F$7:$R$7="Oui")*($I$8:$U$8="BOX")*($I9:$U9))

NOTE: the second/third ranges (in RED) are offset from first range ( In BOLD)